community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE
SOLVED

Adding a column from a different input file

Highlighted
Meteoroid

Hi,

I was wondering how I can add a column from a different input file to the main file. Problem I'm facing; the second input field does not contain ALL combining fiields as the main file.

 

Example.

 

File 1

 

Name     City

Scott       Amsterdam

Eric         New York

John       London

 

File 2

Name     Phone

Scott      +31123456789

 

So, how can I add the column 'Phone' in file 1, and showing no phone number for the rows not mentioned in File 2 (as shown below)

 

Name     City               Phone

Scott       Amsterdam   +31123456789

Eric         New York

John       London

 

I tried it with the Join and Union function, but that will only show the name with the phone number, not the ones without.

 

Thanks a lot,

Floris

 

A Join (on Name) followed by a Union (taking the L(eft) and J(oin) outputs) should do what you need.

 

2016-06-13_14-06-40.jpg

 

Only issue I could think of is if you have trailing spaces on one of the inputs such that the Names arent equal. In which case you will need to use a formula tool to tidy a little first.

 

Sample workflow attached.

Meteoroid

thanks a lot!

 

Atom

I have a similar question to the above, but takes it one step further.  I have two files that I am trying to compare, but need to reference two columns in one file to multiple columns in another file.

 

File 1 includes a list of companies and the year we did work with them. File 2 is the “key” of what priority tier they were in in the respective year.  I would like to pull in the relevant Priority Tier from the relevant year.

 

I was able to build the Alteryx flow shown above, but cant quite figure out how to do this one.

 

Here is a made-up example:

 

In File 1

 

Date                       Company                             Priority tier        

2015                       ABC Company                 

2017                       XYZ Company                  

2014                       My Company                    

 

 

In File 2

 

                                         2017       2016       2015       2014

ABC Company                  3              2              1              2

My Company                     2              1              2              3

XYZ Company                   3              2              NA           2

 

 

Requested outcome

 

Date                       Company                         Priority tier        

2015                       ABC Company                  1

2017                       XYZ Company                  3

2014                       My Company                    3

Labels