Skip to main content Skip to complementary content

Drop field

One or several Qlik Sense 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 "distinct" property of a table is removed after a drop field statement.

Information noteBoth 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.

Syntax:  

Drop field fieldname { , fieldname2 ...} [from tablename1 { , tablename2 ...}]

Drop fields fieldname { , fieldname2 ...} [from tablename1 { , tablename2 ...}]

Examples:  

Drop field A;

Drop fields A,B;

Drop field A from X;

Drop fields A,B from X,Y;

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!