Text format not able to extract properly
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi Team,
Can someone help me to get the text format in Alteryx properly.
THanks
- Labels:
- Expression
- Transformation
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @Amy123 ,
I built the attached workflow:
- used flaf file - mapping one column.
- skip 1st two lines
- dynamic rename to get column names
- text to columns with tab delimiter to get your columns right.
- auto filed to adjust data types
It seems to have worked.
have a look and let me know if it works for you?
cheers!
BR/Jonny
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @Amy123
The "Period Period Part Account in one column" is the column with your "original data", you don't need it. the other columns should be right.
you can ignore the 1st column using the select tool.
open the Select Tool configuration and deselect the 1st column:
and the last column:
can you try now and let me know if it works? see attached
Thanks!