Need help on how to structure this unstructured data.

[stj1120]

Hi all,

Please help me with the workflow on how to prepare this unstructured data to a structured one. 

Thanks in advance.

Kind Regards,

B. Sreenivasa Teja.

[stj1120]

@NicoleJohnson @MarqueeCrew @SeanAdams @patrick_digan 

Please help me with this workflow.

[stj1120]

@ydmuley Please help.

[phani111]

Hi SreenivasTeja, 

Change the delimiter to tab delimiter (\t) in input data tool. You should be able to read in the data.

Regards,

Phaneendra

[stj1120]

I did. But, for some columns I'm unable to parse the data and get the output. For the fields like Customer_ID, Individual_ID_Source etc I'm unable to get the output. Please help me how to get the output. 

Thanks in advance.

Best Regards,

B. Sreenivasa Teja.

[SeanAdams]

Hey Sreenivasa,
It may be worth clarifying how you are looking for the end data to be structured - that way folk can help you get to a solution that meets your needs.



https://community.alteryx.com/t5/Community-Lounge/Posting-for-fastest-possible-solution/td-p/69164