Table to JSON Transforming

Hi everyone,

I have a table need to be converted into json format. My table is

and I need to convert this table into below json format

Please, I need help about this, any help would be appreciated.

Best,

Hi @KKERROXXX , you need to do a groupby on Column1, Column2 and Column3, a couple of aggregations and column rename, and then do a Table to JSON after that.

2 Likes

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.