input Table 1:
input Table2:
Output table must be as shown below:
input Table 1:
input Table2:
Output table must be as shown below:
Please use join datatable with full option…and all the columns you want to join on
After that to remove the same columns or extra columns use a filter datatable
This should give the exact output as you need
Cheers