Alteryx Designer Desktop Discussions

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

Convert Txt data to structured data

Vishwak
6 - Meteoroid

Hi Team 

I am new to convert .txt files to proper data. Could you please help me out to convert unstructured data to structure data.

I am attaching required txt files to convert - please provide me the logic on how to convert those ? - Thanks in advance.

2 REPLIES 2
binuacs
20 - Arcturus

@Vishwak these files are fixed length, so to split the fields you can use the same excel text to column option here. I split the first file with a fixed field length

binuacs_1-1679346698295.png

binuacs_2-1679346807610.png

 

binuacs_3-1679346873288.png

 

 

 

 

 

binuacs_0-1679346542740.png

 

Vishwak
6 - Meteoroid

Thanks, i am unable to open your solution  workflow due to version issue - could you please provide me the screenshot of what is the exact code used in below both the tools ?,Thanks.

Vishwak_0-1679406857214.png

 

Labels