ERROR CSV Reader 3:5 Execute failed: The data row has too few data elements.

Hello,
I am trying to open a text file with CSV reader (or file reader) and I receive this error message :
ERROR CSV Reader 3:5 Execute failed: The data row has too few data elements.
I tried to change the encoding type and none of them works, I still get that message.
I tried to click in all the boxes of “advanced settings” to try out new options, but it doesn’t work either.
My data is sensitive so I cannot share it.
Could someone help out please ?
Thank you,
Regards

Hi @IVHK

Did you search around the Forum.? Try this

gr. Hans

1 Like

Hi @IVHK

your probably have a file which do not have the same amount of elements in every row like:

Row1 1,2,3,4
Row2 1,2,3

In that case you get the error you’ve posted. You can enable the “Support short data rows” option, with this the fourth column gets a missing value in the second row.

I hope this helps :slight_smile:

Best regards
Lars

1 Like

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.