Dates Issue

[#1]

Hi All,

I have one column 'Phase' which contains phases like Design, Dev, SIT, UAT, PROD and I have one more column 'Finish Date' which contains finish dates of projects.

I have one more column 'Project Start Date'. Here Project Start Date is Design Start Date and Design End Date is Finish Date.

Design Finish Date + 1 is 'Development Start Date' and Development Finish Date we have 'Finish Date'.

Development Finish Date +1 is 'SIT Start Date' , SIT Finish Date +1 is 'UAT Start Date', UAT Finish Date +1 is 'PROD Start Date'.

Like that i need to get the data, Could you please help me on this?

I attached req on QVW also

I tried with if(Phase='Design',date(Finish Date,'MM/DD/YYYY')) as Design Finish Date like this i did for all Phases but it's not working in Straight/ Pivot table:

Could you please help me here.

Thanks,

Chiru

[ziadm]

You have to sequence your project phases in the right order.  use applymap to provide you with the right project sequnce

ProjectSeq:

Mapping

LOAD * INLINE [

    Project ID, Sequance

    A1-A2-A3, 1

    A4-A5-A6, 2

    A7-A8-A9, 3

    A10-A11-A12, 4

    B1-B2-B3, 5

    B4-B5-B6, 6

    B7-B8-B9, 7

];

ListProjects:

LOAD [Project ID],

  ApplyMap([Project ID],99) as [Project Sequence],

     Phase,

     [Finish Date]

FROM

(ooxml, embedded labels, table is Sheet1);

Project:

LOAD [Project ID],

  ApplyMap([Project ID],99) as [Project Sequence],

     Phase,

     [Finish Date],

     [Finish Date] - Ndays  as [Start Date]

Resident ListProjects Order by  [Project Sequence];

drop Table ListProjects;

hope this will give you an idea  ..