topic Re: Extract Filename in Reload in QlikView

Extract Filename in Reload

QFanatic — Sat, 16 Nov 2024 18:05:38 GMT

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 — Thu, 17 Sep 2020 16:17:47 GMT

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 — Thu, 17 Sep 2020 16:32:05 GMT

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 — Wed, 14 Oct 2020 13:40:25 GMT

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

Regards,
Brett

QFanatic — Wed, 14 Oct 2020 16:00:04 GMT

Thank you.