Forum Discussion
Solved
converting text into columns and rows
hello,
i need to create columns and add the value from a specific text
this is the model of the text i have
| [{"Date":"2023-12-18T00:00:00","Percentage":50.0},{"Date":"2023-10-11T00:00:00","Percentage":25.0},{"Date":"2024-10-11T00:00:00","Percentage":25.0}] |
i need to convert it like this
It is a Json.
Put Json.Document( ) around your text. It might look something like add a custom column =Json.Document([Column1]) or potentially around your source step.
