topic How to delete a field from specific table..? in QlikView

How to delete a field from specific table..?

kamal_sanguri — Tue, 20 Jan 2015 20:49:23 GMT

Hi,

I have stuck in situation where I need to drop one field from one table.

If I use DROP FIELD <F1> command, the <F1> field from the other table also gets deleted and I do not want to delete it from there. Any help would be greatly appreciated.

Thanks,

Kamal

Re: How to delete a field from specific table..?

jonasheisterkam — Tue, 20 Jan 2015 20:53:17 GMT

drop field A from X;

Re: How to delete a field from specific table..?

chiru_thota — Tue, 20 Jan 2015 21:07:20 GMT

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;