Inconsistent Results When Joining Tables After Adding Keys

[jcountryman]

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
)

[v-yulgu-msft · Accepted solution]

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]

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!