Merge query works but values in other column turn 'null'

[MarlenaPW2]

Hi,

I'm trying to create a new column with people's names (table Risk) based on user id number (stored in a different table - system user). In this particular table, I hoped to do that through merge query. However, once I applied this step, values from other random columns disappeared and now return 'null'. Do you have any advice where I went wrong?

Thanks,

Marlena

[Anonymous]

Hi @MarlenaPW2 ,

This is most likely due to the fact that you have selected the wrong join kind, or that your matching columns are not exactly the same. Please check your join kind and matching columns, and enable fuzzy matching if necessary.

Merge queries overview - Power Query | Microsoft Learn

Best Regards,

Stephen Tao

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

[j_ocean]

Hard to tell from this but common pitfalls here are the "other table" having more than one row for the key being used, and/or you're doing an outer merge and you're seeing nulls in table A for a key that only exists in table B or vice versa.

[KNP]

Hi Marlena,

It's hard to be certain with just screenshots. If you share the code from the advanced editor it would be helpful. (hide any sensitive info)

Based on what you've said though, the only thing I can think that would cause that is the join type you used for the merge. What join type did you use?