Data error found: Value ended with no qoutes while using qoutes mode

[sardarabdullahkhawar]

Hi all, 

hope you guys are doing well. I am trying to load 4 csv files in oracle db. 1 csv is successfully dumped into the table while other 3 are giving errors. I have attached the log file. In some text columns there is arabic. 

[Dana_Baldwin]

Hi @sardarabdullahkhawar 

The error means that your endpoint reading the CSV file source expects all text to be wrapped with quotes but some values in the file have no quotes. Please check the CSV files it threw the error on.

Thanks,

Dana

[shashi_holla]

@sardarabdullahkhawar 

I agree with @Dana_Baldwin, following is one of the errors in the log:

Data error found: Value ended with no qoutes while using qoutes mode - file: E:\QlikShared\790K\CHALLENGE_790K_STG.csv, Record number: 26, Offset: 41470

Open the csv file in notepad++ or similar tool and verify if all records are separated correctly with a quote or you can correct the following values in the endpoint setup to match your data:

Thank you,

[SushilKumar]

Hello team,

If our response has been helpful, please consider clicking "Accept as Solution". This will assist other users in easily finding the answer.

Regards,

Sushil Kumar