Forum Discussion

jcountryman's avatar
jcountryman
Helper I
7 years ago
Solved

Inconsistent Results When Joining Tables After Adding Keys

I'm finding these two Table.NestedJoin expressions to be unequal, and I don't understand what would be causing it? The first runs much faster than the second, but that does me no good if it isn't the same result as the second…

 

Table.NestedJoin(
    Table.ReplaceKeys(
        LEFT_TABLE,
        {[
            Columns = {"UID"},
            Primary = true
        ]}
    ), 
    {"UID"}, 
    Table.ReplaceKeys(
        RIGHT_TABLE,
        {[
            Columns = {"UID"},
            Primary = true
        ]}
    ), 
    {"UID"},
    "SUB_TABLE",
    JoinKind.LeftOuter
)=Table.NestedJoin(
    LEFT_TABLE,
    {"UID"},
    RIGHT_TABLE,
    {"UID"},
    "SUB_TABLE",
    JoinKind.LeftOuter
)

 

  • Hi jcountryman ,

     

    Based on my test, above two methods to merge tables returns the same result.

     

    Please provide sample data so that I can reproduce.

     

    Best regards,

    Yuliana Gu

2 Replies

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee

    Hi jcountryman ,

     

    Based on my test, above two methods to merge tables returns the same result.

     

    Please provide sample data so that I can reproduce.

     

    Best regards,

    Yuliana Gu

    • jcountryman's avatar
      jcountryman
      Helper I

      Thanks for responding. Unfortunately, I can't share this exact data set I'm experiencing trouble with, but that's all the confirmation I need— 100% sure there's something odd with one or both of my tables, not the operations.

       

      Thanks again!