Complex Data Text to Col Parse

[adarshxr]

Hi Team,

Need some help in parsing the atatched data in right format. Tried Text to Coloumns but failed.

[alexnajm]

It looks like JSON so you should use the JSON Parse Tool (alteryx.com)

[aatalai]

What settings did you use? could you import it as a data input as a csv?

[Raj]

@adarshxr is your expected result similar to @alexnajm
if yes please mark his solution as done and  
if not then please share your expected result.

[adarshxr]

Thanks Alex, Can you attach the canvas, need to cross check my settings

[alexnajm · Accepted solution]

Done

[adarshxr]

Thanks a lot Alex,
I need to write the output data in the below format as below, I tried using Dynamic Rename and Cross tab but didn't work,, 

[alexnajm · Accepted solution]

I am not sure what the issue is, the CrossTab is exactly what I'd use here. You can then reorder / rename fields with a Select tool afterwards.

[adarshxr]

Thanks Alex