2 Tables with common columns to merge without duplicates

[NeilSwithin]

Hi,

I am trying to merge 2 tables which has common headers but different values. I want to join them and make it 1 single table without duplicates. Please help me.

Attached are the inputs and the expected result table. Thank you !

[usmanbashir · Accepted solution]

@NeilSwithin - see attached workflow. Hope this helps!

[NeilSwithin · Accepted solution]

Thank a lot, it worked perfectly !  

[NeilSwithin]

I have another very complex query. If possible could you try to help me with your expertise please. Below for your reference:

I am kind of stuck with a scenario for which I'm not able to resolve. I have 2 input tables with 2 common columns. The output must be 1 table with a merge of results from both tables. Each Sub-LOB should show individual totals and the compliance % per Sub-LOB must be displayed along with the other columns causing the non-compliance numbers and relevant control managers. Its pretty complicated, any help with this would be much appreciated. Thanks !