Rewriting a column value with another table column's one

[TormentMaker]

Hey guys, hope its alright.

I'm facing a problem with alteryx, i have 2 tables, like the example below:

1

Name	Address
Rose	Alameda street
Angel	Pirones street
Mario	Ambar street

2

Name	Address	Age
Rose		19
Angel	Pirones street	19
Mario		21

So, basicaly the address column in table 2 does have some empty values depending of the row, so basicaly i want to rewrite them or make another column with the same "address" column from table 1, that's full, someone know how to do this?

[Maskell_Rascal · Accepted solution]

Hi @TormentMaker 

You can use the Join Tool to match on the Name fields, and then keep the address from Table 1 in the output. 

If this solves your issue please mark answer as correct, if not let me know!

Cheers!

Phil

[TormentMaker]

Thanks buddy, that helped a lot, but another issue appeared to me, think you can help?