QVD Creation

[ashok1203]

Hi All,

I have a small requirement. Every month end i want create a month QVD for entire month and in current month i need to create a weekly QVD's and loads the data with previous months QVD. At end of the month Weekly QVDs has not been loaded i need to load only month end QVD. So i need this an automation.

Example: Now we are in September, 2016 (Current Month)

I want QVDs for September 1st to 4th

                         September 5th to 11th

                        September 12th to 18th

                        September 19th to 25th

and then month end QVD for entire month.The same i have to create every month (Current Month) automatically.

Please help on this....

[giakoum · Accepted solution]

testTable:

LOAD * INLINE [

    F1

    a

    b

    n

    h

    y

];

LET vWeekEnd = num(WeekDay(Today()));

LET vMonthEnd = MonthEnd(Today());

LET vToday = Today();

IF vWeekEnd = 6 or vMonthEnd = vToday then

  STORE testTable into testTable$(vToday).qvd(qvd);

ENDIF

[giakoum]

Did it work for you?

[ashok1203]

Thanks It's Working fine for me.

[ashok1203]

Thanks It's Working fine for me.