Source and Target file out come

[Arkouda]

Hi all

I have a attached a file that has a source(s) and outcome tab 

Once tab Source 1 is the original data that has a persons place in the Company, office and team

the second tabs is data we received to change the persons Company, office or team.

What I'm trying to do is replace the old alpha and numeric values with the updated tab to get the final outcome in the outcome tool. I have used the join tool and the find and replace but it's not replacing the new office, team company or adding the new persons (new 2 rows) 

[Arkouda]

excellent - eureka! it worked

[atcodedog05]

Happy to help 🙂

Cheers and happy analyzing 😀

[Arkouda]

I do have one follow up on this which I should have mentioned 

I have a colleague with more than one change - moving to a new office and entity (Co) 

How do you write it so it replaces the Office and Team for that colleague? the Entity and office should be replaced based on if there are more than one action item

Action	To/From	Entity	Office	Team	Person Number
Move - Office	To	ESLG	ALI1	100116	1335190
Move - Entity	To	ESYA			1335190

Desired output would be 

Action	To/From	Entity	Office	Team	Person Number
	To	ESYA	ALI1	100116	1335190

[atcodedog05]

Hi @Arkouda ,

I worked on it and here is the workflow.

Input: I gave an extra row which is unique to consider the general scenario.

Output:

Hope the output is as expected.

Workflow:

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

[Arkouda]

I hope that this is the last request

if there are changes to Office and team for colleague, do I add it to the formula similar to the Action Formula or how would you write it 

Cheers and happy analyzing and supporting me - many Kudos

[atcodedog05]

Hi @Arkouda 

For office (any string datatype) yes you want Last value use Entity formula if you want Blank use Action formula.

Team (any numeric datatype) its not needed.

Hope this helps 🙂

[Arkouda]

something like this to copy if more than one change for a colleague ?

[atcodedog05]

Hi @Arkouda 

Yup checked what you have done should work 🙂

[atcodedog05 · Accepted solution]

Hi @Arkouda 

Here is the workflow where i checked.

Input:

Output:

Hope this helps 🙂

[atcodedog05]

Happy to help 🙂

Cheers and happy analyzing 😀