Store all tables as QVD

[HonestToad]

I am trying to store all my Qlik tables using a loop, however I would like all tables with "Journal" in the title to be stored in a different location.  This is my currently code:

Set vPathQVD='lib://CCure2QlikExport/QVD_Files';

for i=0 to NoOfTables() -1
let vTableName= TableName(i);
If WildMatch([$(vTableName)],'*Journal*') = 0 then
store [$(vTableName)] into [$(vPathQVD)/journal/$(vTableName).qvd] (qvd);
else
store [$(vTableName)] into [$(vPathQVD)/$(vTableName).qvd] (qvd);
endif;
Next;

Unfortunately all tables are getting stored as non-journals - I think its because I am using the $(vTableName) variable incorrectly?

[Nicole-Smith · Accepted solution]

Try this: 

Set vPathQVD='lib://CCure2QlikExport/QVD_Files';

for i=0 to NoOfTables() -1
let vTableName= TableName(i);
If WildMatch('$(vTableName)','*Journal*') = 0 then
store [$(vTableName)] into [$(vPathQVD)/journal/$(vTableName).qvd] (qvd);
else
store [$(vTableName)] into [$(vPathQVD)/$(vTableName).qvd] (qvd);
endif;
Next;

[andoryuu]

Set
If WildMatch([$(vTableName)],'*Journal*') = 0 then
to
If WildMatch('$(vTableName)','*Journal*') = 0 then

[marksouzacosta]

Hi,

We just released a new video in our YouTube channel that may help others looking for some extra info on how to create QVDs. I hope it helps!

IPC Global Tips #6 - Creating QVDs - Regular and Incremental Loads
https://youtu.be/S9L6vWItchs

Regards,

Mark Costa