Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

CSV filed imported with messy columns

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.

1qsgfoR.png

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

How to solve this?

4 Replies
m_woolf
Master II
Master II

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.

Anonymous
Not applicable
Author

You can get it here.

m_woolf
Master II
Master II

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);

Anonymous
Not applicable
Author

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...