Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
We’re experiencing technical issues with our vendor that are affecting license activations for Designer Desktop. We don’t yet have an estimated resolution time. We apologize for the inconvenience and will share updates as we have them.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Putting a new column with code from other file

julius
7 - Meteor

Hi everybody.

 

I have two files, one file has a lot of code (1000 rows) like this:

 

ODA   Type

SCL    regional

BBA    domestic

CPO   domestic

ANF   domestic

 

and the second file has many column and one column named ODA, this file has 1 million rows. I need to put a column on the side of ODA and put if is regional or domestic according the file with codes

 

somebody know how make it?

 

thank you so much

2 REPLIES 2
ThizViz
11 - Bolide
Sounds like a job for the Join tool. The file with lots of columns would go on the left side (top) of the tool and the file with the codes would go on the right (bottom). Join by the ODA field in the tool configuration. From there you can also deselect any columns you don't need and reposition the columns as needed.
@thizviz aka cbridges, Bolide
http://community.alteryx.com/t5/user/viewprofilepage/user-id/2328
julius
7 - Meteor

Thank you 

Labels
Top Solution Authors