Forum Discussion

MarlenaPW2's avatar
MarlenaPW2
Regular Visitor
2 years ago

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

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

Need Help

3 Replies

  • KNP's avatar
    KNP
    Icon for Super User rankSuper User
    2 years ago

    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?

     

     

  • j_ocean's avatar
    j_ocean
    Icon for Helper V rankHelper V
    2 years ago

    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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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.