topic Data error found: Value ended with no qoutes while using qoutes mode in Qlik Replicate

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

sardarabdullahkhawar — Thu, 28 Dec 2023 13:48:40 GMT

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.

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

Dana_Baldwin — Thu, 28 Dec 2023 15:36:12 GMT

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

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

shashi_holla — Thu, 28 Dec 2023 21:12:29 GMT

@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,

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

SushilKumar — Tue, 02 Jan 2024 05:08:59 GMT

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