Merge tables by recordID

[VanG]

RecordID	Customer Phone	Start Date	Total Spent
1	123-345-6789	Date	$
2	987-654-3211	date	$
3	456-123-6789	date	$
4	234-567-8901	date	$
5	567-345-9876	date	$

1	123-345-6789
2	987-654-3211
3	**New Number**
4	234-567-8901
5	*New Number**

I want the 2nd table to replace the values in customer phone ID from the first table based on the Record ID. 

RecordID	Customer Phone	Start Date	Total Spent
1	123-345-6789	Date	$
2	987-654-3211	date	$
3	**New Number**	date	$
4	234-567-8901	date	$
5	*New Number**	date	$

[bpatel]

hi @VanG ,

you will need to change the record ids to a string in order to select them in the find and replace. hope this helps!

[ChrisTX]

Use a Join tool.  Join on Record Id.  If your second table is the right input, select the Customer Phone from the Right table, and de-select the Customer Phone from the Left table.

Chris

[VanG]

@bpatel 

Is it possible to just replace those values instead of creating a new column? Like Lets say I had a table with just the two updated numbers and wanted to replace it this way. 

RecordID	Number
3	**New Number**
5	**New Number**

[bpatel · Accepted solution]

@VanG ,

i think the best way to go about this will be to append a new column, but then you can use a quick formula to modify that existing column.

[rahul_Kumar_koshika]

Hi @VanG

It is better to use a Join tool to the join both the table and apply formula tool to replace those values instead of creating a new column.

Please find the below attached alteryx workflow to obtain the desired output only by using 3 tools (Join, Formula & Select tool).

 If this works, please mark it as a solution.

Thanks.