Need help in JSON transformation

[Padma_]

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

[Raj]

@Padma_ please find the workflow attached

mark done if solved.

[naveenu · Accepted solution]

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.

[jdminton]

You could also try this if multi-row causes some issues due to sorting etc. It should be a little more flexible. Also, you could convert part of the flow to a macro if you will have varying numbers of fields.