Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to avoid loading one field on Loading using *

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

4 Replies
ecolomer
Master II
Master II

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

drop those fields

awhitfield
Partner
Partner

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