Advent of Code is now back for a limited time only! Complete as many challenges as you can to earn those badges you may have missed in December. Learn more about how to participate here!
community Alteryx IO MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Start Free Trial

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
7 - Meteor
‎03-20-2023 12:38 PM

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.

Preview file
559 KB
Preview file
2808 KB
Labels:
Reply
0 Likes
2 REPLIES 2
binuacs
21 - Polaris
‎03-20-2023 02:15 PM

@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

 

Split_Text_200323.yxzp
Reply
0 Likes
Vishwak
7 - Meteor
‎03-21-2023 06:54 AM

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

 

Reply
0 Likes
Christmas in July Blog
designer new user guide
Labels
Top Solution Authors
View All