Self load

[#1]

Hi,

I'm not sure if this is possible, i wanted to do mass formatting, instead of doing one by one,

So, im trying to do the following in one single QVW. but it doesn't work for me.

Any tips?

PIVOT:

LOAD SALES,

          MONTH_YEAR

FROM XX;

STORE PIVOT INTO PIVOT.QVD;

FORMATTING:

LOAD SALES,

          date#(MONTH_YEAR)

FROM PIVOT.QVD;

STORE FORMATTING INTO PIVOT.QVD;

[nagaiank]

Try the following script and see if it does what you want to do. (Change the MONTH_YEAR pattern depending on your data)

PIVOT:

LOAD SALES, Date#(MONTH_YEAR,'the pattern of your MONTH_YEAR data') as MONTH_YEAR;

LOAD SALES,

          MONTH_YEAR

FROM XX;

STORE PIVOT INTO PIVOT.QVD;

FORMATTING:

LOAD SALES,

          date#(MONTH_YEAR)

FROM PIVOT.QVD;

STORE FORMATTING INTO PIVOT.QVD;

[Anonymous]

The missing part, regardless if anything else is correct or not:
date#(MONTH_YEAR) as MONTH_YEAR