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.
Community ChampionHi 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