Hi All,
I need help in JSON transformation, showing the input and expected output here.
Input, have lakhs of rows like below
Header | JSON String |
AvailableGB | 500 |
TotalGB | 600 |
UsedGB | 100 |
AvailableGB | 1900 |
TotalGB | 2000 |
UsedGB | 100 |
Expected output
I tried cross tab, without group by, it outputs only 1 record, but I have lakhs of rows, when I do group by the the out put is in the same above format itself.
AvailableGB | TotalGB | UsedGB |
500 | 600 | 100 |
1900 | 2000 | 100 |
Solved! Go to Solution.
@Padma_ please find the workflow attached
mark done if solved.
Hi Padma,
You just need to insert a multi-row tool to Group By Header so that each group header gets auto-numbered ([Row-1:New_Field]+1); And then use Cross-Tab tool to group by this New_Field.
Hope this helps.