Forum Discussion

dcheng029's avatar
dcheng029
Helper II
1 year ago
Solved

How to replace values on one column with corresponding values from another source

Hi everyone,

 

I am working with 2 data sources; Data Source 1 is a simple list that has the Staff's Name and their corresponding Staff ID which the system uses. Data Source 2 is a list of Job Numbers and the corresponding Staff ID.

 

How would I be able to replace Data Source 2 Staff ID to the corresponding Staff Name from Data Source 1 via Transform Data?

 

Example:

 

Appreciate any help and guidance on this one, thanks in advance!

Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi lbendlin ,thanks for the quick reply, I'll add more.

    Hi dcheng029 ,

    Try using the 'Merge' operation in Power Query.

     

    Best Regards

4 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    1 year ago

    The best way is not to do that.  Let the data model do the work for you.

    • dcheng029's avatar
      dcheng029
      Helper II
      1 year ago

      Hi lbendlin,

      How do I have the data model work for me?

      My question was how to replace the values in one data's column using second data's column values when the Staff ID matches?

      Cheers.

      • Anonymous's avatar
        Anonymous
        Not applicable
        1 year ago

        Hi lbendlin ,thanks for the quick reply, I'll add more.

        Hi dcheng029 ,

        Try using the 'Merge' operation in Power Query.

         

        Best Regards