topic Re: CSV filed imported with messy columns in App Development

CSV filed imported with messy columns

Anonymous — Fri, 21 Sep 2018 03:49:55 GMT

I'm testing the Qlik Sense Cloud. I imported a file with 190,000 lines. The file is completely intact, meaning each column contains its correct values (already tested with Excel's filter).

However, when I create a new application and run Insights, it is blending data from different columns as if they were in a single column.

I've tried to import 2 times but the problem continues.

How to solve this?

Re: CSV filed imported with messy columns

m_woolf — Fri, 21 Sep 2018 15:36:51 GMT

It would help to see the actual data file. I'm guessing from the picture that QV needs to be told what the delimiter is.

Re: CSV filed imported with messy columns

Anonymous — Fri, 21 Sep 2018 15:54:01 GMT

You can get it here.

Re: CSV filed imported with messy columns

m_woolf — Fri, 21 Sep 2018 16:26:58 GMT

I attached a qvw that loads the data.

This is my load script:

LOAD @1,

@2,

@3,

@4,

@5,

@6,

@7,

@8,

@9,

@10,

@11,

@12,

@13,

@14,

@15

FROM

(txt, codepage is 1252, no labels, delimiter is ';', msq);

Re: CSV filed imported with messy columns

Anonymous — Fri, 21 Sep 2018 16:29:43 GMT

I know Qlikview and I know it works. What I said is the problem is in Qlik Sens Cloud. There, after creating an application and run "insight" I get that messy results...