QlikWorld 2020 Global Conference. Join us to discover how to get the most from your data. Act fast. Register now and save.

Drop field

在执行脚本期间,可以使用 drop field 语句随时从数据模型和内存中删除一个或多个 Qlik Sense 字段。

备注: drop fielddrop fields 都是允许的格式,效果完全一样。 如果未指定任何表格,字段将从全部表格中删除。

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;