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

AngelosPachis

Hi @RodrigoOlmedo , 

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

Hope that helps,

Regards,

Angelos

example.yxmd