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 !
Solved! Go to Solution.
@NeilSwithin - see attached workflow. Hope this helps!
Thank a lot, it worked perfectly !
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 !