Display Parent Value for Child

[mansoorsheraz]

Hi,

I have ran into an issue where I want to display the Parent's parameter value as default value for every child that is missing its own value. Here is the table showing my problem:

So in the ID STMT column for Row 1 for the child "Chicago Department of Aviation, Illinois" I want to have "cityofchicago.org_cafr_2019" displayed.

Similarly for  "City of Chicago Department of Transportation, Illinois" in Row 4 , I again want to display "cityofchicago.org_cafr_2019" in the ID STMT column

I couldnt find any alternative to the LookUp function on the Charts. Can someone help me with this ?

Regards.

[mansoorsheraz]

Can anyone help me here ?

[AshutoshBhumkar]

Hello,

You can create a mapping table with Name Child and ID STMT. You will have 'City Of Chicago, Illinois' wise cityofchicago.org_cafr_2019 value

And lookup the value with Name Parent whenever the value in ID STMT is null (or length is 0).

Hope this helps.

Thanks,
Ashutosh

[mansoorsheraz]

Didn't work as ID STMT is coming from another table. I tried using mapping and applymap.