Solved: Drop fields with * - Qlik Community

Anonymous · ‎2013-09-30

Hi,

In a script after a LOAD I have to delete some empty fields of a table, that are like 'FIELD1', 'FIELD2', 'FIELD3', etc.

Is there any possibility to delete dynamicaly like:

DROP Fields FIELD* From TABLE ?

Report Inappropriate Content · ‎2013-09-30

Oh okay... This is one other site I stumbled across about a wildcard search for dropping fields

Report Inappropriate Content · ‎2013-09-30

Here is a solution from anther discussion posted....

Anonymous · ‎2013-09-30

It's not really a solution, but I solved my problem the same way with a loop:

for i = 1 to 15

LET TempFieldName = 'Demandes_ICCOUT' & $(i);

IF FieldNumber('$(TempFieldName)','Demandes') <> 0 then

Drop Field $(TempFieldName) From Demandes;

ENDIF;

next i

The fact is that in my example I have 15 fields that can exists.

What I want is to know if I could solve the problem with any number or caracters, with just a prefix like:

Drop Fields 'Demandes_ICCOUT*' From Demandes

Report Inappropriate Content · ‎2013-09-30

Oh okay... This is one other site I stumbled across about a wildcard search for dropping fields

Anonymous · ‎2013-09-30

Thanks! That's what I was expecting for, I will be able to make my own solution.

Drop fields with *