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) 

[AbhilashR]

Hi @Arkouda, I have attempted to build a solution and replicate your final outcome. Let us know if this isnt what you were looking for.

[atcodedog05]

Hi @Arkouda ,

Here are approaches using Join and Find & Replace tool.

Input : 2 Source tabs given by you.

Output :

Workflow:

And i just found that Find & Replace is better approach if you want to maintain Data's sorting order. Join resort at output.

Hope this helps 🙂

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

[grazitti_sapna]

Hi @Arkouda , you can do this using find and replace tool.

Thanks.

[Arkouda]

Hi Grazzitti

The find and replace tool works but it's not bringing in the added colleagues

[Arkouda]

Hi Atcodedog05 🙂

If I wanted to use the find and replace tool, is there a way to add the additional colleagues as well? it's only showing the replaced colleagues not added 

Thank you 

[atcodedog05]

Hi @Arkouda 

Let me take a look into it.

[atcodedog05]

Hi @Arkouda ,

I was able to modify the Find & Replace branch to add new rows.

Output:

Please check and let me know🙂

[Arkouda]

Almost getting there 

Forgot one last thing

I need to also keep the colleagues who do not have any changes 

I added 3 more records in source 1, they need to come over to the outcome

[atcodedog05 · Accepted solution]

Hi @Arkouda ,

That would not be issue. The same thing will work because Find of Find & Replace tool is on Source 1.

Here is the updated workflow with the updated file.

Output:

But since Source 1 doesnt have Action and To/From the source extra rows will be Null

Hope this helps 🙂