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

Datasets

Accepted answers

afv2688

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

All comments

afv2688

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

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703