How to avoid loading one field on Loading using *

[#1]

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

[ecolomer]

Can you explain more, please.?

It is possible you upload an simple example?

[sunny_talwar]

Drop them after you load them.

Table:

LOAD *

FROM XYZ...;

DROP Fields Field1, Field2, Field3;

[gautik92]

drop those fields

[awhitfield]

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