Week Conversion by using Month or Year. ( Date filed is not avilable on source)

[#1]

Hi fouks,

Could you please help me to week conversion by using month or year. Actully week & date is not matianed one retailer.  All the retailers has week conversion, We need to convert all retailes to one week level format. I attached the excel for source format.

Thanks & Regards,

Radha Krishna

RETAILER	STORE	YEAR	YEAR/MONTH	MONTH	MONTH NAME	UNIT SALES
A	1	2011	201105	5	MAY	230
B	2	2011	201106	6	JUNE	305
A	1	2011	201107	7	JULY	330
A	1	2011	201108	8	AUGUST	292
A	2	2011	201109	9	SEPTEMBER	437
B	1	2011	201110	10	OCTOBER	411
B	1	2011	201111	11	NOVEMBER	589
A	1	2011	201112	12	DECEMBER	603
C	1	2012	201201	1	JANUARY	523
A	1	2012	201202	2	FEBRUARY	711
C	1	2012	201203	3	MARCH	632
C	1	2012	201204	4	APRIL	596

[tresesco]

Try something like:

LOAD RETAILER,

     STORE,

     YEAR,

     [YEAR/MONTH],

     MONTH,

     [MONTH NAME],

     [UNIT SALES],

    Week(MakeDate(YEAR, MONTH,1)) as Week

FROM