Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Author

First 1 LOAD * FROM cvs did the trick 

I do have embedded labels.

This is the result I wanted

result.jpg

Thanks!

View solution in original post

3 Replies
Not applicable
Author

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

Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

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
Author

First 1 LOAD * FROM cvs did the trick 

I do have embedded labels.

This is the result I wanted

result.jpg

Thanks!