Forum Discussion

Housny's avatar
Housny
New Member
2 years ago
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","P...
  • spinfuzer's avatar
    2 years ago

    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.