Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Incomplete import of CSV file data to qlikview

Hi all,

I have the following CSV file data:

V4.0;GL;R;Delta;IF;;09-14-2012;51630;209

100;3267;1770178000;;;;;;;;;;;;9587.5;;;P_6401_RRIT1010_macajen_20120817;1770423000;;201201

100;6225;1770178000;;;;;;;;;;;;5162.5;;;P_6401_RRIT1010_macajen_20120817;1770423000;;201201

100;7957;1770178000;;;;;;;;;;;;-14750;;;P_6401_RRIT1010_macajen_20120817;1770423000;;201201

100;3267;1770178000;;;;;;;;;;;;9587.5;;;P_6401_RRIT1010_macajen_20120817;1770423000;;201202

100;6225;1770178000;;;;;;;;;;;;5162.5;;;P_6401_RRIT1010_macajen_20120817;1770423000;;201202

I went to EDIT SCRIPT, TABLE FILES, and browsed for this file.

In the file wizard, I can only see up to 9 columns. I suspect this is because the first row line is only up to the 9 column.

But the data I really need are those rows 2 and below. These data are up to 21 columns.

How can I import that entire 21 columns of data based on above CSV file structure?

Thanks in advance.

1 Solution

Accepted Solutions
Jason_Michaelides
Luminary Alumni
Luminary Alumni

If you can ignore the first line completely then in the table load window set some lines for the header. If you need to load the first line too then use

Load

@1 AS A,

@2 AS B,

@3 AS C,

.

.

.

@22 AS V

From...csv;

Hope this helps,

Jason

View solution in original post

2 Replies
Not applicable
Author

Posting an image of the CSV data, as my orig post looks mangled:

CSV data.JPG

Thanks in advance.

Jason_Michaelides
Luminary Alumni
Luminary Alumni

If you can ignore the first line completely then in the table load window set some lines for the header. If you need to load the first line too then use

Load

@1 AS A,

@2 AS B,

@3 AS C,

.

.

.

@22 AS V

From...csv;

Hope this helps,

Jason