Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
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