Hello!
Have this requirement:
Have a business process. For each business process, some KPIs have been identified.
Have configured a lookup where I am storing KPI related columns alongwith process name.
My ask is simple, lookup where i have stored kpi related information, filtering out this month's data leaves me four rows:
Two rows pertaining to same process but two different KPIs
Two rows pertaining two other different processes but one KPI each
P1, KPI1, col1, col2, kpi_value
P2, KPI21, col1, col2, kpi_value
P2, KPI22, col3, col4, kpi_value
P3, KPI31, col1, col2, kpi_value
Have configured another lookup, storing business process name and kpi name alongwith formula to evaluate that kpi.
P1, KPI1, formula1 (col1 + col2)
P2, KPI21, formula21 (col1 + col2)
P2, KPI22, formula22 (col3 + col4)
P3, KPI31, formula31 (col1 + col2)
Now kpi_value for each of the KPI in the first lookup has to be evaluated using the formula from the second lookup.
Have already tried several other answers but to no avail.
| eval kpi_value = [|inputlookup formulae.csv | eval search=formula]
But the above query always picks up the first column from the second lookup and evaluates the value. Not every KPI has those same columns. For example: if the formulae.csv lookup has col1 + col2 in the formula value, it evaluates for all KPIs except for P2, KPI22
Please help.
... View more