topic Re: Strange Data Anomaly - csv script import in QlikView

Strange Data Anomaly - csv script import

DavidAinsworth — Sat, 16 Nov 2024 03:21:30 GMT

Hi there,

Thank you in advance for any guidance.

The attached file contains 3 rows of data, separated by a semi-colon (;), the first row is the headers then there are two rows of data.

When I import this data the Load process only seems to identify a single row of data and not two rows.

how can I troubleshoot this issue and correct the script load process so it works?

Cheers

Dave.

Re: Strange Data Anomaly - csv script import

lironbaram — Mon, 10 Jun 2019 05:14:25 GMT

all you need to do is to change the Quoting from MSQ to none

see attach image

Re: Strange Data Anomaly - csv script import

DavidAinsworth — Mon, 10 Jun 2019 07:24:31 GMT

Good morning

Thank you for your assistance with this issue, choosing the supplied settings worked with the file example.

I have attached a further update to the file example, which contains a few further rows. The selection of None for the Quote symbols seems to have a problem with other data which is contained within the file.

What would you recommend?

Cheers

Dave

Re: Strange Data Anomaly - csv script import

lironbaram — Mon, 10 Jun 2019 08:06:49 GMT

it seems this actually a XML file there is a lot of desgin stuff in the file not data

it's not really a csv of a table,

so i don't think the problem is the Quoting ,

if the file is an xml or html it's different story and you will need to write a code to transfer the data into a table

Re: Strange Data Anomaly - csv script import

jonathandienst — Mon, 10 Jun 2019 08:12:34 GMT

The problem is the embedded HTML containing line breaks in line 5. The quoting rules from delimited text files do not include the line breaks, so each line break starts a new line, regardless of the quoting option. I could not find a way to override this behaviour. Can you suppress this column when you generate the CSV file?

Re: Strange Data Anomaly - csv script import

DavidAinsworth — Mon, 10 Jun 2019 08:17:02 GMT

Good morning

Thank you for your assistance reviewing this data, there is a description field which contains these line break characters.

Unfortunately I am not able to create a data extract without this data, I only have the ability of creating this full export file.

Kind Regards

Dave