How to import huge txt file with comma delimiter and new line delimiter vertical bar?

[slobo]

I'm having issue with importing huge txt file where delimiter is comma and there is also newline delimiter which is vertical bar.

I've tried to import with \0 delimiter so I could separate everything after with Text to tool but the error I'm receiving is that Input tool is unable to import because number of fields is greater than 16M fields. 

What could I do? Thanks.

[Raj]

can you share the file

[slobo]

Sorry, no. Sensitive data.

[Raj]

ok, can you create one which is not sensitive and can be shared

[slobo]

I've shared the file, sample data. 

[binuacs]

@slobo One way of doing this

[slobo]

I cannot open your workflow package, it says it may be because of yours newer version of Alteryx. Thanks

[Raj]

First split to rows using "|" as a delimiter

second split to the column using "," as a delimiter

then use dynamic rename to make the first row as header

[binuacs]

@slobo Open the workflow in a notepad++ and change the version and save it, then you will be able to open it in your alteryx designer

[binuacs]

@slobo below is the input file configuration