How to load data from Text File using Alteryx Desktop

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

Data Investigation

Accepted answers

All comments

alexnajm

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?

amsrivastav

Hi Alexnajm,

Please find sample data as attached and please provide me sample Alteryx flow, that would be very helpful.

Thanks

Amit

Data.txt

birlatrimayapr

https://www.birlatrimayaa.in/

flying008

Hi, @amsrivastav

Could you please upload the data table as your want result?

录制_2024_01_03_14_15_53_930.gif

录制_2024_01_03_14_23_53_425.gif

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,