Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Import data from csv with 2 tables

I have a csv-file which contains two tables. See the example below.

textbox15,textbox2
08-01-2013 (01:34:11),Jaar: 2013
textbox42,textbox44,
c01,B2B

I import the second table with the wizzard using 'header is 6 lines', but how do I import the first table without importing fields form the second table?

Thanks for your help in advance.

Ruud

1 Solution

Accepted Solutions
Not applicable

Re: Import data from csv with 2 tables

First 1 LOAD * FROM cvs did the trick 

I do have embedded labels.

This is the result I wanted

result.jpg

Thanks!

3 Replies
Not applicable

Re: Import data from csv with 2 tables

Hi,

Do you have to use a csv file or you can change it in xls?

In this case you can put the tables in two different sheets.

Let us know

regards

Giampiero

Re: Import data from csv with 2 tables

You can use the First keyword.

First 6 Load * from ...mysource...

maybe first 5 if you have embedded labels


talk is cheap, supply exceeds demand
Not applicable

Re: Import data from csv with 2 tables

First 1 LOAD * FROM cvs did the trick 

I do have embedded labels.

This is the result I wanted

result.jpg

Thanks!

Community Browser