Importing Text File is not Working

Hi,

I have never had any problems importing delimited .txt files, but this week Alteryx seems to have stopped working properly. I am doing exactly what I have always done, but it is not working. All data is imported as "Null"

Attached a screenshot of how I normally import the files and another of the results. For some reason now every single data becomes "null" after importing.

Does anyone have a clue?

Text Import - Configuration Wizard.png

Text Import - Result.png

Input

Bug

Accepted answers

MarqueeCrew

It looks (see warning) like you have too many delimiters in some rows. You might need to clean the data up.

All comments

MarqueeCrew

It looks (see warning) like you have too many delimiters in some rows. You might need to clean the data up.

GabrielBacarin

I opened the file with EditPad Lite, and there is nothing wrong with it. There is the exact amount of fields for each line.

Here are the first 2 lines:

and so on....

What bothers me is that any other importer will read it, except alteryx. Alteryx is supposed to read this. Is there anything else I can try?

Thanks a lot

GabrielBacarin

You were right. There is an extra pipe in the end of every data row.

To fix it instead of removing the extra pipe of all the millions of lines, I added an extra pipe on the first row, and now it is working.

Thanks a lot!

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703