Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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.
You can get it here.
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);
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...