topic Re: Dynamic Load of a QVD in QlikView

Dynamic Load of a QVD

michaeldburt — Thu, 24 Mar 2016 13:50:03 GMT

Hello Everyone-

I am trying to write a script that will dynamically choose and load a QVD based on the QVD being the latest loaded version.

For background, I have an app that loads data from a table, and creates a QVD named [Table__$(vTimeStamp)]

In a separate app, I'm trying to load the newest version, or the most current "Timestamp" QVD.

Does anyone have experience with this type of situation?

Re: Dynamic Load of a QVD

swuehl — Thu, 24 Mar 2016 14:43:28 GMT

You can scan all QVDs in your folder, creating a table with filenames, like

For Each vFile in FileList('$(FolderPath)\Table_*.qvd')

Files:

LOAD '$(vFile)' as Name,

SubField(Subfield('$(vFile)','_',-1),'.qvd',1) as Timestamp //here you parse the timestamp,may need to adapt, also // using Timestamp#() to interprete as timestamp

AutoGenerate 1;

Next vFile

Then search for max timestamp:

TMP:

LOAD FirstSortedValue( Name, -Timestamp) as LastFileName

Resident Files;

Let vLastFile = Peek('LastFileName',0,'TMP');

Re: Dynamic Load of a QVD

michaeldburt — Thu, 24 Mar 2016 16:20:58 GMT

This was exactly what I had in mind. I had to change the code around a bit but the framework is excellent. Thank you for the assist!