-
Re: QVDs Files
Wallo Atkinson Oct 31, 2017 4:54 PM (in response to Meryem Touijer)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?
-
Re: QVDs Files
Mark Ritter Nov 1, 2017 8:23 AM (in response to Meryem Touijer)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.
-
Re: QVDs Files
Jonathan Dienst Nov 1, 2017 8:35 AM (in response to Meryem Touijer)You cannot use a wildcard in the store command.
-
Re: QVDs Files
Mark Ritter Nov 1, 2017 8:36 AM (in response to Jonathan Dienst )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.
-
Re: QVDs Files
Jonathan Dienst Nov 1, 2017 8:38 AM (in response to Mark Ritter)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
-
-
-
Re: QVDs Files
Jonathan Dienst Nov 1, 2017 8:37 AM (in response to Meryem Touijer)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]