Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Joining 2 Excel Files and replacing one column with current output

Arkouda
8 - Asteroid

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 IDFull/Part Time
File11234Full Time
 1235Full Time
 1236Part Time
   
 Colleague IDFull/Part Time
File 21234Part time
 1235Part time
 1236Full time
8 REPLIES 8
vizAlter
12 - Quasar

@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.

Arkouda
8 - Asteroid

@vizAlter 

 

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

 

 

 

 

atcodedog05
22 - Nova
22 - Nova

Hi @Arkouda ,

 

Here is a workflow for the task.

 

Input : files given by you

Output : 

atcodedog05_0-1601609680700.png

Workflow

atcodedog05_1-1601609699002.png

 

Hope this helps : )

 

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

atcodedog05
22 - Nova
22 - Nova

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 : )

 

Arkouda
8 - Asteroid

Hi Atcodedog05

 

 

Im not getting the the outcome results when I add the 2 source files together - take a look at the work flow i have attached 

 

 

 

 

 

atcodedog05
22 - Nova
22 - Nova

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

atcodedog05_0-1601653630998.png

Output from my workflow. Or are you using different data.

Arkouda
8 - Asteroid

it worked - thank you 

atcodedog05
22 - Nova
22 - Nova

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 🙂

Labels
Top Solution Authors