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.

How to get a desired output from a JSON indexing data ?

AKPWZ
8 - Asteroid

In my limited knowledge I tried few things, like I used "Regex tool", "Multi-row tool", "Cross Tab" etc but nothing is working for me. 
Can someone please help how I can learn and get the desired output?
Here is the input data screenshot: - 

AKPWZ_0-1657388803729.png

 

Desired Output: - 

AKPWZ_1-1657388866733.png

 

And this is what I was trying to do:

AKPWZ_2-1657388932674.png


Please find the excel file (Input data and desired output) as attached :-

 

10 REPLIES 10
FilipR
11 - Bolide

Grouping by ID in the Cross Tab tools and replacing Append Fields with Join will fix the issue.

 

Please see attached.

 

FilipR_0-1657624021907.png

 

Labels
Top Solution Authors