Putting a new column with code from other file

[julius]

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

[ThizViz · Accepted solution]

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.

[julius]

Thank you