Source and Target file out come

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)

Change Co Office Team.xlsx

Preparation

Accepted answers

atcodedog05

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 🙂

Join_v4.yxzp

atcodedog05

Hi @Arkouda

Here is the workflow where i checked.

Input:

Output:

Hope this helps 🙂

2 instance.yxmd

All comments

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.

sample.yxmd

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 😀👍

Join_v3.yxzp

grazitti_sapna

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

Thanks.

Source and Target file out come-GS.yxzp

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

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703