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

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

prees959 — Wed, 25 Nov 2020 16:16:04 GMT

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 — Wed, 23 Aug 2017 06:02:17 GMT

Hi,

You can use

"Drop Fields 'key_prefix' , 'key_binder';

at the end of the script, before you store.

tresB — Wed, 23 Aug 2017 06:12:58 GMT

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 — Wed, 23 Aug 2017 06:18:54 GMT

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 — Wed, 23 Aug 2017 07:25:32 GMT

thanks everyone!