Simple way to loop through qvd's and remove two fields

[prees959]

Hi,

I need to loop through a folder with about 20 QVDs and remove two fields from each one : 'key_prefix' and 'key_binder'.

Is there any easy way to do this and Store the resulting QVDs in a new folder?  

Many thanks,

Phil

[stabben23]

Hi,

You can use

"Drop Fields 'key_prefix' , 'key_binder';

at the end of the script, before you store.

[tresesco · Accepted solution]

Try like:

for each File in filelist (Root&'\*.' &qvd)

tab:

     Load

               *

     From  path\$(File);

     Drop fields 'key_prefix' , 'key_binder';

     Store tab into <new path>;

next File

[micheledenardi]

NewTable:

Load *

From C:\YourPath\QvdCommonName*.qvd (qvd);

Drop Fields 'key_prefix' , 'key_binder' from NewTable;

Using * (in the FROM statement) after the common part of the name (of your 20 QVDs) Qlik load all QVDs which name match with the part after the *.

[prees959]

thanks everyone!