topic Re: Import data from csv with 2 tables in QlikView

Import data from csv with 2 tables

Thu, 14 Feb 2013 11:21:08 GMT

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

Re: Import data from csv with 2 tables

Thu, 14 Feb 2013 11:28:22 GMT

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

Gysbert_Wassenaar — Thu, 14 Feb 2013 11:28:24 GMT

You can use the First keyword.

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

maybe first 5 if you have embedded labels

Re: Import data from csv with 2 tables

Thu, 14 Feb 2013 11:33:47 GMT

First 1 LOAD * FROM cvs did the trick

I do have embedded labels.

This is the result I wanted

Thanks!