interval match and peek

[#1]

The client is a sewing machines institution. The client would like access dashboard to be able to analyze what is the end date and capability sewing machines are available at a particular day. To facilitate this client has provided records of recent database of sewing machine availability. Each database has information about hour’s sewing machine available, workspace, start date and end date.

Here is the respective data, workspace AA is allocated for 100 minutes from 1/1/2014 to 1/12/2014 and 200 minutes from 1/14/2014 to 1/24/2014. Workspace BB is allocated for 100 minutes from 1/8/2014 to 1/17/2014 and 200 minutes from 1/19/2014 to 1/24/2014.

[Anonymous]

Final:

LOAD [Work center],

    Date

FROM

(ooxml, embedded labels, table is Sheet1);

Temp_Capacity:

LOAD [Work center],

    [Start date],

    capacity

FROM

(ooxml, embedded labels, table is Sheet2);

//

//

Cap2:

LOAD

    [Start date],

    if(len(Peek([Start date]))=0 or [Work center]<>peek([Work center]),'1/1/2020',date(peek([Start date])-1)) as End_date,

    [Work center],

    capacity

Resident Temp_Capacity

order by [Work center], [Start date]  desc;

drop table Temp_Capacity;

left join (Final)

IntervalMatch(Date,[Work center])

LOAD

    [Start date],

      End_date,

    [Work center]

Resident Cap2 ;

[#3]

right answer

[Anonymous]

suma its not like that there will be a button which says correct answer below my reply .