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

Exclude column when Load*;

Hi

I want to exclude/remove a column named ID when I load data from a SQL databas. Since I have so many columns I would prefer to remove this one instead of writing all of the columns I want to load.

Thanks in advance.

/A

1 Solution

Accepted Solutions
pennetzdorfer
Creator III
Creator III

Use the drop field statement.

load * from ...;

drop field ID;

Regards,

Florian

View solution in original post

2 Replies
Gysbert_Wassenaar

There's no way to specify a list of fields to exclude. Let the wizard create the statement for you including a preceding load and the comment out the lines with the columns you don't want. You can comment a line out by putting two slashes at the beginning, i.e. //. If you have a number of consecutive lines you want to comment out then you can select them with the mouse, right click and select Comment.


talk is cheap, supply exceeds demand
pennetzdorfer
Creator III
Creator III

Use the drop field statement.

load * from ...;

drop field ID;

Regards,

Florian