topic Re: Drop Temp all the Files in the App in QlikView

Drop Temp all the Files in the App

Anonymous — Fri, 09 Oct 2015 12:19:22 GMT

Hi All,

I have created several temp Fields in a App.

Like tempabcd, tempbox , tempram , tempmax.

Now I want to drop all the temp Fields with one syntax.

Please help me on the same

Re: Drop Temp all the Files in the App

avinashelite — Fri, 09 Oct 2015 12:22:24 GMT

Drop fields fiedsname1,fieldname2 ;

etc

Re: Drop Temp all the Files in the App

avinashelite — Fri, 09 Oct 2015 12:23:39 GMT

One or several QlikView fields can be dropped from the data model and thus from memory at any time during script execution, by means of a drop field statement.
The syntax is:

drop field[ s ] fieldname [ , fieldname2 ...] [from tablename1 [ , tablename2 ...]]

Both drop field and drop fields are allowed forms with no difference in effect.
If no table is specified, the field will be dropped from all tables where it occurs.

Examples:

drop field A;

drop fields A,B;

drop field A from X;

drop fields A,B from X,Y;

Re: Drop Temp all the Files in the App

Anonymous — Fri, 09 Oct 2015 12:31:09 GMT

I have more than 20 fields ...will Drop tables '*_temp';

Re: Drop Temp all the Files in the App

avinashelite — Fri, 09 Oct 2015 12:39:03 GMT

no I don't think your syntax will work, you need to specify all the fields

Re: Drop Temp all the Files in the App

Gabriel — Fri, 09 Oct 2015 12:50:45 GMT

Hi,

May be try this

SUB DropTable(TableName);

IF LEFT(TableName,4) ='Temp' THEN

DROP TABLE [$(TableName)];

ENDIF

END SUB

Then after each table you will have a CALL function as this

CALL DropTable('TempRESULT')

Hopefully this will start a thinking

Re: Drop Temp all the Files in the App

Peter_Cammaert — Fri, 09 Oct 2015 14:21:39 GMT

The community always supplies you with one or more answers, if you take the time to perform a search.

This one may help you: Qlik Tips: Removing Fields with a Wildcard

Peter

Re: Drop Temp all the Files in the App

Anonymous — Tue, 13 Oct 2015 05:26:41 GMT

Unluckily it doesn't work in my location

Re: Drop Temp all the Files in the App

Peter_Cammaert — Tue, 13 Oct 2015 06:47:18 GMT

Yes, I noticed that the link is dead. Weird because it points to the blog of stephen-x.redmond. I also know this to be a QlikView Cookbook for Developers article (by the same author), don't know if you got that one?

I'm sure the site is only temporarily off-line.

Peter

Re: Drop Temp all the Files in the App

jonathandienst — Tue, 13 Oct 2015 06:51:16 GMT

The link to Stephen's blog works fine for me.

Re: Drop Temp all the Files in the App

Peter_Cammaert — Tue, 13 Oct 2015 07:12:21 GMT

Probably still in your DNS cache. New DNS queries can't resolve www.qliktips.com anymore...

There is something rather final about this and this may shed some light on the situation: his youtube channel states that after moving to Qlik, he became responsible for creating the same content on an official capacity.

I'll see if I can find it somewhere else...

Re: Drop Temp all the Files in the App

Peter_Cammaert — Tue, 13 Oct 2015 07:29:44 GMT

The technique does something like this:

FOR i = 1 TO NoOfFields('MyTable')

LET FieldName = FieldName($(i), 'MyTable');

IF '$(FieldName)' Like 'F*' THEN

LET Command = 'DROP Field [$(FieldName)];';

$(Command)

END IF

Define this piece of code in a SUB with two parameters (tablename, wildcardfieldspec), replace the corresponding values in the body with the proper parameter names, and you're on your way.

Peter