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.
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
Hi Anonymous ,
Something surely we are missing since if you see my comment we are getting those data as well which is not matching for example in location column values CA04 and DA04 are present in merged table which is not matching in both tables.
Could you please share your steps what you followed and also share your output what you are getting so it would help us to understand where we are going wrong.