hurry help

[#1]

i have 2 dates in my dimension like

   1    20/04/2014

   1   21/04/2014

   2    20/04/2014

   2    21/04/2014

i want display each date in different dimension like

[#2]

U can try the below script:

T1:

Load date as Date1

from table_name

where date=20/04/2014;

T2:

Load date as Date2

from table_name

where date=21/04/2014;

[#3]

Can you please provide some more details.......

[MK_QSL]

Temp:

Load RowNo() as NO, Date Inline

[

  Date

  21/04/2014

  22/04/2014

];

NoConcatenate

Final:

Load NO Resident Temp;

Join

Load Date Resident Temp;

Drop Table Temp;

[#5]

Hi,

Like this?

Table:

Load

DateField

If(DateField='20/04/2014',DateField) as DateField1,

If(DateField='21/04/2014',DateField) as DateField2

From YourSource;

Hope this helps ..!