QVDs Files

[Anonymous]

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

[Anonymous]

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]

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.

[jonathandienst]

You cannot use a wildcard in the store command.

[rittermd]

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.

[jonathandienst]

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]

[jonathandienst]

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