Error during data set load

[Avishek1]

I am getting an error while loading a dataset :

Too many fields in record #34

Please let me know what can be causing this issue and how to resolve it

[afv2688 · Accepted solution]

Hello @Avishek1 ,

This error sometimes appears with txt (or csv) datasets.

To avoid it try to do the following:

• Read the file with no delimeter
• Use a tex  to columns tool to parse then the data
• Use the dynamic rename tool afterwards to input the parsed headers

Let me know if this works for you

Regards

[Avishek1]

@afv2688  Thanks it worked however my header of my data set is appearing now as one of the record as a result for any manipulation  header also getting associated, is there any way we can define 1st row as header

[afv2688]

Hello @Avishek1 ,

On the developer tools there is one called dynamic rename. There you can configure the tool and select the option for "take names from first row of data"

That should do it!

Regards