IF CONTAINS in special case

[ravitejapaideti]

Hi all,

I have 3 input tables X,Y,Z with a common field BUS_UNIT and the target table (T) has column BUS_UNIT aka 'A'. It should have unique values of all the three columns combined from X, Y and Z. I am using UNION and UNIQUE nodes for this. Now the target has other column B and C, which should contain values YES/NO. If the value in target column 'A' (BUS_UNIT value) exist in Input table X, then value in target Column B is YES, else NO. 

For Column C in target table T, Yes/No values should populate if the value in column 'A' (BUS_UNIT) exists in input table Y. No if it doesn't. How and where should I write the formula for this?

Attaching an image for better understanding.   TIA

[Luke_C · Accepted solution]

Hi @ravitejapaideti 

I don't fully understand the requirements, but this should get you on the right path:

1. Create a field to list the table name
2. Union then group by the BUS_UNIT, concatenate the table name
3. Then write a formula to check if the concatenated table names contain the field (I did one as an example, you can do the rest if it's what you need).

Hopefully this helps and is somewhat in the right direction - let me know if I misunderstood.

[ravitejapaideti]

Hi @Luke_C , thanks for your response. I'll try the above approach. Meanwhile, I am attaching the requirement in detail, if that helps understanding better.