I have downloaded file zip, when I am Unzipped there is file in csv format and all data coming in single cell/row with double inverted comma .
there are garbage records in first 4 rows and actual data starting from 5th row
I have set up data import line from 5th row
when running I am getting error
Error 1:
"Data.csv cannot be read multi-threaded (cannot synchronize on record boundaries); set the 'Force Single Threaded' option and run again"
I tried to fix Delimiters by double inverted comma ( " ) but its giving another error
Error 2:
"Input Data (4): Cannot use a quote character as a field delimiter: "
Solved! Go to Solution.
Hi @faisal9999 have you tried the single threaded option it's a configuration option in the Input Data Tool?
Thank you Joseph it got resolved
Just happened to me to. Couldnt find this option. thank you for the post and the answer!
User | Count |
---|---|
107 | |
82 | |
72 | |
54 | |
40 |