Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Need help in JSON transformation

Padma_
7 - Meteor

Hi All,

I need help in JSON transformation, showing the input and expected output here.

 

Input, have lakhs of rows  like below

 

HeaderJSON String
AvailableGB500
TotalGB600
UsedGB100
AvailableGB1900
TotalGB2000
UsedGB100

 

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.

 

AvailableGBTotalGBUsedGB
500600100
19002000

100

3 REPLIES 3
Raj
16 - Nebula

@Padma_ please find the workflow attached

mark done if solved.

naveenu
6 - Meteoroid

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
12 - Quasar

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.

Snag_9b45764.png

Labels