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 |
Solved! Go to Solution.
@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.
Here is the source from 2 files and need them to merge into one but need the assignment category remapped updated with the 2nd source
the outcome should be the outcome on the tab
Hi @Arkouda ,
Here is a workflow for the task.
Input : files given by you
Output :
Workflow
Hope this helps : )
If this post helps you please mark it as solution. And give a like if you dont mind : )
Hi @Arkouda ,
Here is a workflow with Find & Replace
Workflow
Both approaches are attached in the Workflow file.
Hope this helps : )
If this post helps you please mark it as solution. And give a like if you dont mind : )
Hi @Arkouda ,
Whats the issue i am getting the outcome similar to given by you. Can you mention with a snapshot whats the error.
Outcome given by you
Output from my workflow. Or are you using different data.
it worked - thank you
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 🙂