How do I create variable using table column

[Anonymous]

Dear team

How do I create variable from

T1:
LOAD * INLINE [
CDate
01/31/2015
02/29/2015
03/31/2015
04/30/2015
05/31/2015
01/31/2015
02/29/2015
03/31/2015
04/30/2015
05/31/2015
01/31/2015
02/29/2015
03/31/2015
04/30/2015
05/31/2015
];

like

let vDT1 = COB_31012015.qvd;

let vDT1 = COB_28022015.qvd;

let vDT1 = COB_31032015.qvd; and like wise

Thanks for help

[#2]

Satish,

I don't know what happens with your dates but it is really strange. First, I thnk that February 29, 2015 doesn't exist. In my sample I changed it by 02/28/2015.

This looks to answer your need even I think we can make it simpler.

Load Distinct

  CDate

Resident T1;

T2:

Load

  RowNo() as No,

  CDate as CDat

Resident T1

Order by CDate;

FOR i=0 to NoOfRows('T2')-1

Let vDt$(i) = 'COB_' & Date(Peek('CDat',$(i),'T2'),'MMDDYYYY') ;

NEXT

Regards

Gilles