RecordIDCustomer PhoneStart DateTotal Spent 1123-345-6789Date$2987-654-3211date$3456-123-6789date$4234-567-8901date$5567-345-9876date$ 1123-345-67892987-654-32113**New Number**4234-567-89015*New Number** I want the 2nd table to replace the values in customer phone ID from the first table based on the Record ID. RecordIDCustomer PhoneStart DateTotal Spent 1123-345-6789Date$2987-654-3211date$3**New Number**date$4234-567-8901date$5*New Number**date$

Merge tables by recordID

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	$

Workflow

Tips and Tricks

Join

Preparation

Accepted answers

bpatel

@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.

find and replace record ids V2.yxmd

All comments

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!

find and replace record ids.yxmd

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

@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.

find and replace record ids V2.yxmd

Quick Links

This months top contributors

AkimasaKajitani 387

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335