Hello,
I have a table as shown below:
My goal is to get the Schedule flag from "FACT Schedule" Tab as highlighted in yellow below;
![2.PNG 2.PNG](/t5/image/serverpage/image-id/10350i1AC27CB23DC8B9B5/image-dimensions/717x314?v=v2)
I tried all ways to link them in the script (data model) when I select [New_Area] field the [SCH Schedule Flag] data is not responding as shown below (I think because [New_Area] & [SCH Task Discipline] is not connected)
![Capture.PNG Capture.PNG](/t5/image/serverpage/image-id/10356iE9EC353E97ED2B2E/image-size/large?v=v2&px=999)
My desired output should be like this:
when I select "MECHANICAL ENG" in [New_Area]
![12.PNG 12.PNG](/t5/image/serverpage/image-id/10357iFE2E1A86AA55F582/image-size/large?v=v2&px=999)
when I select "SOFTWARE ENG" in [New_Area]
![13.PNG 13.PNG](/t5/image/serverpage/image-id/10358i735AAB32DCC46C49/image-size/large?v=v2&px=999)
when I select "CONTROLS ENG" in [New_Area]
![14.PNG 14.PNG](/t5/image/serverpage/image-id/10359i405872367BDCC979/image-size/large?v=v2&px=999)
Sorry for the long post, I tried all the ways and checked with all my sources but couldn't able to get the desired output.
Could anyone help me? I sincerely thank you again for all your valuable time and help. Attached are the files for reference
thanks again
Bhavesh