Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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...
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