Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Register for the upcoming Live Community Q&A Session - and don't forget to submit your questions for @DeanS regarding the future role of analytics here.
SOLVED

Importing Text File is not Working

Highlighted
6 - Meteoroid

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?

 

 

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner
It looks (see warning) like you have too many delimiters in some rows. You might need to clean the data up.
Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.
Highlighted
6 - Meteoroid

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:

 

Data início|Hora Início|Data Fim|Hora Fim|Operadora|Filial|Origem|Praça|Célula|Nome do Agente|Login SisAmil|Login Workflow|Nome do Cliente|Marca Ótica|Motivo|Número do Protocolo
31/12/2015|23:58:40|01/01/2016|00:08:20|AMIL|PARANÁ|Teleatendimento|Tamboré|Noturno|Name of the person|GECARDOSO|GECARDOSO|CLAUDIA PAIVA RIOS|871985420|Direcionamento|="28266002474"|

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

 

 

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner
Didn't see this was part of a longer thread.
Highlighted
6 - Meteoroid

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!

Labels