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

[IVHK]

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

[HansS]

Hi @IVHK

Did you search around the Forum.? Try this

Execute failed: Too few data elements

I was getting this error using the CSV Reader node, and selecting the “Support Short Lines” option in the Settings tab resolved it, thanks for the tip!

gr. Hans

[laaaarsi]

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

Best regards
Lars