topic Re: Drop the field in QlikView

Drop the field

sona_sa — Tue, 31 Jul 2018 11:52:32 GMT

Hi,

I have 3 table and I want to delete or drop 3 field at a single line code from each table.

Is it possible ? If yes, Please suggest.

Regards,

kfoudhaily — Tue, 31 Jul 2018 11:54:55 GMT

felipedl — Tue, 31 Jul 2018 11:55:23 GMT

Hi,

If they aren't in other tables you can just use

drop fields X,Y,Z;

if they are present elsewhere, you'd have to specify the table for each one.

PabloTrevisan — Tue, 31 Jul 2018 11:56:32 GMT

Hi iTree,

you can try use

Drop Fields fiel1,field2,field3

If you use this command after the three tables, it will remove from all tables, if they are different fields, execute after the 'FROM' of each table

sona_sa — Tue, 31 Jul 2018 13:45:01 GMT

Suppose

I have :

Now I want to delete by using single line code - From Table 1 -- A, Table 2 -- D, Table 3 -- G,

Not Multiple line of multi-line Drop statement.

Thanks for Reply. Any Idea please suggest.

vishsaggi — Tue, 31 Jul 2018 14:22:33 GMT

After loading all these tables in the last line just do

Drop Fields A,D,G;

Chanty4u — Tue, 31 Jul 2018 14:41:09 GMT

drop the fields A,B from Tabl1,Table2;

jagadeeshbv29 — Fri, 22 Sep 2023 15:42:01 GMT

how to drop multiple field names like this 'David muffle' In the table