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.