topic Re: Exclude column when Load*; in QlikView

Exclude column when Load*;

Wed, 06 Mar 2013 15:01:56 GMT

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.

Re: Exclude column when Load*;

Gysbert_Wassenaar — Wed, 06 Mar 2013 15:07:06 GMT

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.

Re: Exclude column when Load*;

pennetzdorfer — Wed, 06 Mar 2013 15:25:52 GMT

Use the drop field statement.

load * from ...;

drop field ID;

Regards,

Florian