We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

How to parse and align the json data

AKPWZ
8 - Asteroid

How can I align the given data in a specific row and column, can someone please help me. Thank you

 

Input Data:

AKPWZ_0-1661768332858.png

 

Output Date:

AKPWZ_1-1661768380058.png

 

Sample file attached: -

3 REPLIES 3
Luke_C
17 - Castor
17 - Castor

Hi @AKPWZ 

 

Here's one way. Separate the headers from the rows and join the two datasets together. Then you just have to cross tab. 

 

Luke_C_0-1661801606813.png

 

AKPWZ
8 - Asteroid

@Luke_C  thank you so much! It's working for me. :)

Luke_C
17 - Castor
17 - Castor

@AKPWZ Happy to help! Be sure to mark the solution so others can find it easily in the future.

Labels
Top Solution Authors