SOLVED
Putting a new column with code from other file
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
julius
7 - Meteor
‎02-21-2017
10:58 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
Solved! Go to Solution.
Labels:
- Labels:
- Join
2 REPLIES 2
ThizViz
11 - Bolide
‎02-21-2017
12:11 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
http://community.alteryx.com/t5/user/viewprofilepage/user-id/2328
‎02-22-2017
10:03 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you
