Input Text Data

Bill9

Hello,

I attached the sample file that we want to input that to Alteryx and start to use some of the awesome tools for analysing. Is these a way to do it in Alteryx with this format which is directly downloaded from SAP R3? We have thousands of files as the sample. but we cannot input to Alteryx in the first step.

By the way, when we open the sample text file with Excel with Unicode text and save it as itself. then we can do them in Alteryx with the Saved Unicode text format files. It waste energy and time if someone have a good solution to input them in Alteryx.

Thanks in advance!

sample3.txt

BrandonB

This is because your files have different schemas when you use the tab delimiter if you try to do that within your Input Data tool. Try reading them in undelimited with these settings:

No delimiter - This looks like \0 in your setting 5

Uncheck the "First Row Contains Field Names" box

Then use a Text to Columns tool afterwards to parse with \t if you want to split on the tab delimiter afterwards