Drop Temp all the Files in the App

[Anonymous]

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

[Peter_Cammaert]

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...

[Peter_Cammaert]

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

NEXT

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