Forum Discussion
merge two table with full outer join values
Hi Anonymous
(1)You can use Append function in Query Editor .Append two tables and return a new table like this :
(2)Delete the duplicate rows with null in Ct val. And then replace the null value with 0 .
(3)Close & Apply to Desktop view , and the result is as shown :
Best Regards
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous Are you doing this in Power Query Editor? Can you share your Advanced Editor code?
i am trying merge table option in power bi desktop
Hi Anonymous ,
Hope you are following the below steps. Since after following these steps I am getting expected output.
1. Selecting merge queries as new
2. Merge tables with location column from both the m1 and actual table:-
3. Take CT_value column only from actual table:-
4. Replace null with 0 in ct_value column
final output
Please let me know if i am missing something.
Thanks,
Samarth
i have unmatached rows between i want get that rows i have updated my question . i have done merge query but i want unmatched rows also
