How to load data from Text File using Alteryx Desktop
- 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 Folks!!
I have to create Alteryx which can read data from the Text file.
1. Source of the file is Text File.
2. It holds five columns (Col_A,Col_B,Col_C,Col_D and Col_E) and are TAB seperated.
3. Col_C having a value which is TAB separated as well
3.1. Delimiter is not fixed, it can be any delimiter but same within a file, i.e. for 02 Jan, it may have TAB delimiter however on 3 Jan, it can be COMMA or SEMICOLON or anything else, this hold true only for Col_C
Please suggest how to create Alteryx flow for it
Thanks
Amit
- Labels:
- Data Investigation
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
You'll likely have to read it in with no delimiter, and then use Alteryx from there to parse through, using some sort of RegEx logic to determine where Column C starts and ends.
Can you share sample data with us?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi Alexnajm,
Please find sample data as attached and please provide me sample Alteryx flow, that would be very helpful.
Thanks
Amit
- 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, @amsrivastav
Could you please upload the data table as your want result?
Output | ||||
ABCDE | FGHIJ | KLMNO | PQRST | UVWXY |
123-1112-AAA | 9/11/2022 | 12A12 AB12A | ABCD | ABCDEFGHI, ABC13-ABC|"234, 12ABCDE-AD-123" |
143-2222-BBB | 9/11/2022 | 321 DA-ABCDE 43ABC ABC13-ABC | ABCDEFGFFD000000 | ABCDEFGHI, ABC137-ABC, 12345AB-AB-123ABC, |
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi Flying008
Can you please upload your Alteryx flow which you have made, that would be helpful.
Thanks
Amit
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi, @amsrivastav
I can't upload any flow files because our security policy, but if you show your want output results, maybe can check it.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
![](/skins/images/12DF86F0CA96E81F3ABF675C1590B6DD/responsive_peak/images/icon_anonymous_message.png)