Data editor & for each

[schmidtj]

Hi,

i think i have a pretty simple question.

I would like to set an array in my data editor script with a few values.

I would like then to export a QVD file as often as i have values in that array.

I did the following so far:

SET list = ValueList('1', '2');

FOR EACH var IN list

    STORE "MY_TABLE" INTO [$(v_My_Path)/folder\$(var).qvd](qvd);

NEXT VAR;

This is working, but it only exports one file with the name: '1,2.qvd'.

Can somebody tell me how to correct this?

As well can somebody tell me if there is a good script documentation for the data editor?

The official online qlik help doesnt cover all the aspects of that script language i think.

Thanks a lot.

[kaushiknsolanki · Accepted solution]

HI in that case you can create a inline table and use that in script like below

Inline:

Load * inline [

Field

1

2

];

Let vCount = noofrows('Inline');

For i =0 to $(vCount) -1

     Let var = peek('Field',$(i),'Inline');

     STORE "MY_TABLE" INTO [$(v_My_Path)/folder\$(var).qvd](qvd);

Next

Regards,

Kaushik Solanki

[schmidtj]

Thank you, thats it!

[schmidtj]

Do you know by any chance a good source for documentation for this script?

[kaushiknsolanki]

Hi,

Community is one and you can also look at the Help site.

Rest all is your logical thinking about how to use them.

You should also give a try for the one which stalwar1‌ suggested.

Regards,

Kaushik Solanki