Using Merge Query (Full Outer join) expand data in Get & Transform (Power Query)
I have two data sets; a list of unique commodity code and a list of unique company codes. I need to explode/expand the resulting data set so I have a list of Commodity codes by Company code. For example I have 10 company code and 200 Commodity codes. The result set would be 10*200 = 2,000 records. Using Get & Transform (Power Query) merge query (Full Outer Join) could facilitate this but it is still requiring me to match on a field and if the field doesn't match the Full Outer Join is not working correctly. I had to add a dummy blank column to each table and use that in the join to work around this. Less than ideal but works.