Hello there,
I'm trying to match values on 2 tables based on identifier on both tables.
I'm having an issue returning null value when i use power query merge function between 2 tables.
here is my example:
table 1 has 3 columns (A,B,C)
table 2 has 3 columns (C,D,E)
columns C is the main columns in both tables which is the identifier on both tales.
on table 2, cells on columns (D and E) may have different values but they have same to ID on columns C.
85% of IDs on table 1(C) matches Table 2(c), but using power query, it shows only one match on both tables and the rest shows as Null values.
Any help please?
Bookmarks