Drop fields with *

[Anonymous]

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 ?

[#2]

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

http://community.qlik.com/message/172747

[Anonymous]

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

[#4 · Accepted solution]

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

Qlik Tips: Removing Fields with a Wildcard

[Anonymous]

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