Replace data fields

[RodrigoOlmedo]

Hello all !! please your help with this issue:

I have a table with these catalog fields:

CODE	COUNTRY	STATE	CITY
001	USA
011	USA	CA
012	USA	CA	SAN DEIGO
013	USA	TX
014	USA	TX	AUSTIN

And other one with customers:

CUST ID	COUNTRY CODE	STATE CODE	CITY CODE
001	001	011	012
002	001	013	014
003	001	013	014

What I need is to replace the code with country / state/ city names. Please your advice on this.

Thank you very much.

Rodrigo

[apathetichell]

Join tool- match Code with City Code will match it. You have to figure out how you want your final data though. Do you need columns for each city/state/zip?

Since the city code is the most specific if you match via that you can then take the rest of the information over.

[AngelosPachis · Accepted solution]

Hi @RodrigoOlmedo , 

You may have to change the structure of your data slightly, before joining the two streams together

Hope that helps,

Regards,

Angelos

[RodrigoOlmedo · Accepted solution]

@AngelosPachis , thank you very much for your help !!

I have another issue, let me make another post.

Regards

Rodrigo