Reg:Dynamically update file name

[#1]

Hi all,

    I am having following scenario.ln that every month .qvw file name has to change automattically/dynamically.

Ex:

    if current month file name is ABC_05_2012 (May month). when next month (june) comes fle automattically should get changed like ie;ABC_06_2012.

kindly let me know if any of you have thughts on this.

-Jai

[oscar_ortiz]

You can use variables to make the load more dynamic.

LET vMonth          = Num(Month(Today()),'00');

LET vYear          = Year(Today());

Then in your load statement:

LOAD

     *

FROM

     ABC_$(vMonth)_$(vYear)

;

Good luck

Oscar