Too Many Fields in Record 2 when importing .csv

Question

Hello,

i have an issue while importing a .csv, the result is an error "Too many fields in record 2", with the data_file.csv, attached, so i am unable to open the file with Alteryx only.

Delimiter within is semi-colon.
I need the first record and the 2nd one as header, so all the records in the file should be given in the output, so i can work out from there.

I have tried many of the suggestions on the topic but still the issue persists,

Thank you very much

data_file.csv

result.PNG

settings.PNG

jNunez · Accepted Answer

In the file you attached the first record is "Sensor Technology;10/08/2023". Is that actually necessary? If not, you could start data import on line 2.

If it is necessary, you can read the data in with \0 as the delimiter. This reads each line in your document as a single field. Then from there you can split it out with the text to columns tool. If you need the field names in the second row, then you can add a "Select Records" tool and Use a "Dynamic Rename" tool to get the field names fixed.