Forum Discussion
Performing two merges and get the result based on conditional?
So I have ABC table that needs to lookup the address from two other tables. I want to bring in the address from table1 if the address was found in table1. I want to bring in the address from table2 i...
Vijay_A_Verma
Most Valuable Professional
Most Valuable ProfessionalThere can be various alternative approaches. I would like to know the key field on which you are performing merge between ABC and Table 1 / 2 and the result field. Then I can supply the right approach to you.
They all share the same unique identifier. Let's say its phone number.