Hi,
I have two queries in Power Query, each with a list of product codes in the first column and sales values in the second column.
I would like to merge these queries to create a new query that has a single instance of each product code, taken from the two queries mentioned above, in the first column and the sales values from the first table in the second column and the sales values from the second table in the third column of the new merged query.
I know the mechanics of merging the queries in PQ but the problem I have is that while most of the product codes are common to both queries, there are a few in each table that are not in the other.
Can someone please tell me how to set up the merged query so that a single instance of all product codes in both tables are included, together with their associated sales values as described above?
Thanks!
I have two queries in Power Query, each with a list of product codes in the first column and sales values in the second column.
I would like to merge these queries to create a new query that has a single instance of each product code, taken from the two queries mentioned above, in the first column and the sales values from the first table in the second column and the sales values from the second table in the third column of the new merged query.
I know the mechanics of merging the queries in PQ but the problem I have is that while most of the product codes are common to both queries, there are a few in each table that are not in the other.
Can someone please tell me how to set up the merged query so that a single instance of all product codes in both tables are included, together with their associated sales values as described above?
Thanks!