Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Record not present in dataset

Bruce_V
7 - Meteor

I am receiving an error when loading a .txt file. The error says: "A field was missing ... in record 23844". 

 

What surprises me is when looking into the data the total imported records stops at 23,670. Can anyone explain this mismatch to me? I would expect that it stops on the error thus still displaying a total of 23843 records. 

 

I hope someone can clarify so I can further investigate the error.

 

Best,

Bruce

2 REPLIES 2
messi007
15 - Aurora
15 - Aurora

@Bruce_V,

 

Could you share the data with us? It will help us to investigate with you.

 

Regrads,

Bruce_V
7 - Meteor

@messi007 

Unfortunately no I can't. I have gotten a little further though. My .txt file seems to have blank lines which seem to be causing the / an error. 

Labels