Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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;