Consolidate all the rows from two tables - Urgent

[Anonymous]

Hi Experts,

I need really urgent help.

I have two tables(Actuals and Plan)

In Actual tables i have 35 columns and Plan table 15 columns.

If Atuals Amount is existing for some rows, but the plan is not there.

If plan is exsiting for the same rows but Autals is not there.

Below is my same data.

Please help

I want to combie the all the rows from both tables.

I tried to merge the tables but I'm getting the expected result.

[v-yuta-msft]

@Anonymous ,

Have you solved your issue by now? If you have, could you please help mark the correct answer to finish the thread? Your contribution will be much appreciated.

Regards,

Jimmy Tao

[v-yuta-msft]

@Anonymous ,

Based on the senario you have described, have you tried merge table using "anti join"? 

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.