topic Re: How to avoid loading one field on Loading using * in QlikView

How to avoid loading one field on Loading using *

Fri, 07 Oct 2016 06:44:47 GMT

Hi All,

I have weekly file which will be updated weekly.each week a new column will be added to the file.

so in my script i ll be using * to load all the fields.

Now My problem is i have don't need 3 fields in my script,how to remove them while loading?

Best Regards,

Reena

Re: How to avoid loading one field on Loading using *

ecolomer — Fri, 07 Oct 2016 06:47:11 GMT

Can you explain more, please.?

It is possible you upload an simple example?

Re: How to avoid loading one field on Loading using *

sunny_talwar — Fri, 07 Oct 2016 06:47:23 GMT

Drop them after you load them.

Table:

LOAD *

FROM XYZ...;

DROP Fields Field1, Field2, Field3;

Re: How to avoid loading one field on Loading using *

gautik92 — Fri, 07 Oct 2016 06:50:23 GMT

drop those fields

Re: How to avoid loading one field on Loading using *

awhitfield — Fri, 07 Oct 2016 13:35:38 GMT

Load all the fields using * then use DROP FIELD, to get rid off the ones that you don't want:

Drop Field

One or several QlikView fields can be dropped from the data model and thus from memory at any time during script execution, by means of a drop field statement.
The syntax is:

drop field[ s ] fieldname [ , fieldname2 ...] [from tablename1 [ , tablename2 ...]]

Both drop field and drop fields are allowed forms with no difference in effect.
If no table is specified, the field will be dropped from all tables where it occurs.

Examples:

drop field A;

drop fields A,B;

drop field A from X;

drop fields A,B from X,Y;

Back to Script Statements and Keywords.

HTH Andy