topic Re: Drop fields with * in QlikView

Drop fields with *

Anonymous — Mon, 30 Sep 2013 14:57:58 GMT

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 ?

Mon, 30 Sep 2013 15:19:39 GMT

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

Anonymous — Mon, 30 Sep 2013 15:32:12 GMT

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

Mon, 30 Sep 2013 15:41:00 GMT

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

Anonymous — Mon, 30 Sep 2013 15:49:56 GMT

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