https://community.fabric.microsoft.com/t5/Developer/Merge-queries-rows-and-columns/m-p/698093#M19482 <P>Hi,</P><P>&nbsp;</P><P>I have a doubt, I merge two queries (one is all the information from planned production and the other is the information from actual production). So I merge the planned production query with the actual production query (to add the colum of actual production) but I want that with this merge appears all the matches between them, the products planned that are not produced and the products that we produced and was not planned.</P><P>&nbsp;</P><P>the problem is that I can not make this three links, is it possible to do it? I know when you make a merge, there is a drop down with options below, but I have only managed to get the coincidents ones in the two tables + the ones that do not match with the first table.</P><P>&nbsp;</P><P>Thanks in advance!!!</P> Thu, 23 May 2019 08:15:31 GMT fsanz03 2019-05-23T08:15:31Z https://community.fabric.microsoft.com/t5/Developer/Merge-queries-rows-and-columns/m-p/698093#M19482 <P>Hi,</P><P>&nbsp;</P><P>I have a doubt, I merge two queries (one is all the information from planned production and the other is the information from actual production). So I merge the planned production query with the actual production query (to add the colum of actual production) but I want that with this merge appears all the matches between them, the products planned that are not produced and the products that we produced and was not planned.</P><P>&nbsp;</P><P>the problem is that I can not make this three links, is it possible to do it? I know when you make a merge, there is a drop down with options below, but I have only managed to get the coincidents ones in the two tables + the ones that do not match with the first table.</P><P>&nbsp;</P><P>Thanks in advance!!!</P> Thu, 23 May 2019 08:15:31 GMT https://community.fabric.microsoft.com/t5/Developer/Merge-queries-rows-and-columns/m-p/698093#M19482 fsanz03 2019-05-23T08:15:31Z