Forum Discussion
dcheng029
1 year agoHelper II
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...
- Anonymous1 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
Anonymous
1 year agoNot applicable
Hi lbendlin ,thanks for the quick reply, I'll add more.
Hi dcheng029 ,
Try using the 'Merge' operation in Power Query.
Best Regards
dcheng029
1 year agoHelper II
Ahhh yesss I completely had a mind blank and forgot about this process option, all solved now thank you for the heads up Anonymous