Forum Discussion
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 Numb...
Hi lbendlin ,thanks for the quick reply, I'll add more.
Hi dcheng029 ,
Try using the 'Merge' operation in Power Query.
Best Regards
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.