Forum Discussion

PCarson00's avatar
PCarson00
Frequent Visitor
2 years ago
Solved

Unexpected comparison results

I have a power query table which is a merge of two tables. It performs fine but I want to compare two columns with two other columns. Spec and SPEC (one is PUDPipeData.SPEC)   I have added a condi...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi PCarson00 ,

    Based on the information you have provided, It seems that the result appears to be a Cartesian product. There are several possibilities that could cause this:
    First, check that the relationship between the two tables is not a many-to-many relationship before you merge them. The Cartesian product result often occurs in the case of many-to-many relationships.
    If it's not a many-to-many relationship, check what mode you're using for merge.

    For each different mode, the final number of rows returned will vary.
    Merge queries overview - Power Query | Microsoft Learn

    Best Regards,
    Dino Tao
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi PCarson00 ,

Based on the information you have provided, It seems that the result appears to be a Cartesian product. There are several possibilities that could cause this:
First, check that the relationship between the two tables is not a many-to-many relationship before you merge them. The Cartesian product result often occurs in the case of many-to-many relationships.
If it's not a many-to-many relationship, check what mode you're using for merge.

For each different mode, the final number of rows returned will vary.
Merge queries overview - Power Query | Microsoft Learn

Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.