Get Qty & Value for Analysis Date from Date Slabs

[girish_talele]

Dear Experts,

As shown below, We have one table having Plant Wise certain Date Slabs and corresponding Qty & Value for that date slab.

Second table contains a Plant & Analysis date.

In second table we want to fetch the Qty & Value for Analysis Date which is falling in the respective Date Slab.

Please guide how to map the requirement.

Regards,

Girish.

[marcus_sommer]

You need to match your FromDate and ToDate per IntervalMatch to your AnalysisDate or a Date from a master-calendar which is then connect with the AnalysisDate.

- Marcus

[Kushal_Chawda]

DataTable:

mapping LOAD Plant&FromDate+iterno()-1 as Key,

          Qty&'|'&Value as Data

FROM Table

while FromDate+iterno()-1<=EndDate;

Analysistable:

LOAD Plant_1,

          AnalysisDate,

          subfield(applymap('DataTable',Plant_1&AnalysisDate),'|',1) as Qty_1,

          subfield(applymap('DataTable',Plant_1&AnalysisDate),'|',2) as Value_2

FROM Table;