In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

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

Complex Data Text to Col Parse

adarshxr
7 - Meteor

Hi Team,

 

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

8 REPLIES 8
alexnajm
18 - Pollux
18 - Pollux

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

Screenshot 2024-02-26 084033.png

aatalai
14 - Magnetar

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

Raj
16 - Nebula

@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
7 - Meteor

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

alexnajm
18 - Pollux
18 - Pollux

Done

adarshxr
7 - Meteor

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
18 - Pollux
18 - Pollux

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.

Complex Data Text to Col Parse.png

adarshxr
7 - Meteor

Thanks Alex

Labels
Top Solution Authors