Mapping

ritumishra01 — Fri, 15 Nov 2024 20:54:00 GMT

We have fact table with below fields

pgcode

acode

county

amount

we have different pgcode as cw,as,in,ht,hp,in and many more

similarly we have different acode 01,02,04,07

now we need to generate report based on pgcode and acode so we difjned a new field in fact table as combined_field

now what is required is if we select cw pgcode it should include ht,hp,in data as well with all the aid codes

how to implement this in report data load editor can not do in front end as we are again formung kpi table and pulling that table .

Re: Mapping

MatheusC — Wed, 31 Jul 2024 19:17:38 GMT

@ritumishra01

What I tried to understand is that you want to combine values into a filter value, like your example, it would be something like this.

if(Match(pgcode,'ht','hp','in'),'cw',pgcode) as new_pgcode

- Matheus

topic Mapping in App Development

Mapping

Re: Mapping