Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
meryemtoui
New Contributor

QVDs Files

Hello ,
I need your help ...
I have an excel source file it's loads every day.
I want to store it in qvd files but without putting the date, I mean instead of putting   "Store [HLD_8D] into $ (vQVD_Load) HLP_8D_20171024.qvd"
I put just "Store [HLD_8D] into $ (vQVD_Load) HLP_8D _ * .qvd"
and automatically, it will loads all months in my source excel.

it's possible?

Thank you

6 Replies
atkinsow
Valued Contributor II

Re: QVDs Files

Not sure I understand the question.

That store command will create a qvd. 

So are you saying you want a process that grabs the newest excel file from a folder and then creates a corresponding QVD without you having to change the name in the script every time?

Is the date you want to use in the Excel file name?  Or do you just want the qvd named with the current date?

rittermd
Honored Contributor

Re: QVDs Files

If each day is a separate excel file you can copy them to the same folder.

Then when you Load use *.xls and it will load all of the files in that folder and then you can store into a QVD with whatever name you want.

If I understand what you are asking.

MVP
MVP

Re: QVDs Files

You cannot use a wildcard in the store command.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
rittermd
Honored Contributor

Re: QVDs Files

In the Load.  I thought he wanted to put all of his excel files into a QVD that the name was not dependent on having a date in it.

MVP
MVP

Re: QVDs Files

Create a variable - lets call it vDate for now:

     vDate = '20171024'

Then use the store command

    Store [HLD_8D] into [$(vQVD_Load) HLP_8D_$(vDate).qvd]

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
MVP
MVP

Re: QVDs Files

I am referring this statement in the OP's post:

    Store [HLD_8D] into $ (vQVD_Load) HLP_8D _ * .qvd


That is not a legal statement

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Community Browser