Extract Filename in Reload

[QFanatic]

hi

I have inherited a model that does the following:

Table:

load *

from \\server\location\myfile*.qvd(qvd);

How do I 'catch' the actual QVD's name (e.g. myfile123.qvd), because currently, I cannot see what files are reloaded in this statement.

All help appreciated.

[edwin · Accepted solution]

you need to loop through each QVD.

look at this https://community.qlik.com/t5/QlikView-App-Development/Reading-qvds-in-loop/m-p/852816

in your loop expression (what he used was File), $(File) will be your full file name, just parse it.

[QFanatic]

thanks Edwin.

If all the QVD's in the Filelist have exactly the same structure, this loop will create One Table, as they would automatically concatenate?

[Brett_Bleess · Accepted solution]

Have a look at the following Design Blog post, may be the piece you are missing, I think.

https://community.qlik.com/t5/Qlik-Design-Blog/Loops-in-the-Script/ba-p/1473543

Regards,
Brett

[QFanatic]

Thank you.