concatenate using variable path

gerhardl — Tue, 16 Aug 2011 10:03:45 GMT

Hi,

Our system generated reports every day, and then sends ot to a folder called "Einstein Reports".

If I open this folder there will be folders for every year, in such a folder will be folders for every month and in such a folder will be folders for every day.

So the last day of June will be L:\Einstein Folders\2011\062011\30062011

And the next day will be L:\Einstein Folders\2011\072011\01072011

I have one file where I use the following to determine the latest folder to work from and then choose the extract need:

Let LMonth = Date(Today(),'MMYYYY');

Let LDay = Date(Today()-1,'DDMMYYYY');

Load [1],[2]

From

This will then replace the file every day.

How can I concatenate these transaction extracts, starting from a specific date? So from the 15th of August (

L:\Einstein Folders\2011\082011\15082011) I want to Load the Daily_Transaction Extract and then every day after that I want it to concatenate up until the latest file as determined by the variable path.

Any ideas?

Thanks - G

topic concatenate using variable path in QlikView

concatenate using variable path