Drop the field

[sona_sa]

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,

K

[kfoudhaily]

https://help.qlik.com/fr-FR/qlikview/November2017/Subsystems/Client/Content/Scripting/ScriptRegularS...

[felipedl]

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]

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]

Suppose

I have :

Table 1
A
B
C

Table 2
D
E
F

Table 3
G
H
I

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]

After loading all these tables in the last line just do

Drop Fields A,D,G;

[Chanty4u]

or

drop the fields  A,B from Tabl1,Table2;

[jagadeeshbv29]

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