Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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
Contributor III

Re: Exclude column when Load*;

Use the drop field statement.

load * from ...;

drop field ID;

Regards,

Florian

2 Replies

Re: Exclude column when Load*;

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
Contributor III

Re: Exclude column when Load*;

Use the drop field statement.

load * from ...;

drop field ID;

Regards,

Florian

Community Browser