Joining 2 Excel Files and replacing one column with current output

Hi All

This is easy to do in Excel, but I have 2 files and I want file 2 to replace the outcome in a column

So the column Colleague ID does not change but the Full/Part time will change when I add file 2. I have tried several tools, join and replace but not getting the outcome - it maybe a simple selection on my end

	Colleague ID	Full/Part Time
File1	1234	Full Time
	1235	Full Time
	1236	Part Time

	Colleague ID	Full/Part Time
File 2	1234	Part time
	1235	Part time
	1236	Full time

Preparation

Accepted answers

atcodedog05

Hi @Arkouda

If it worked can you please mark the post and solution. And give a like if you don't mind 😀👍

Cheers and Happy Analysing 🙂

All comments

vizAlter

@Arkouda — Can you attach your files for input and desired output, both?

btw, "Find Replace" tool works with String data type(s) only... so try to change the data type of [Colleague ID] field to one the String types, in both tables.. it should work.