Updating current field from another input

khap

Could you please give a sample workflow for the below scenario? Thank you for your helping.

I have two input sources from 2 Excel workbooks. For example,

Input1 from workbook1

ID SchoolName

1 LEHIGH VALLEY Elementary

2 ABC School Altoona

3 Lansdale Penn High School

4 Wilmington Elementary Braddock

5 Philly Elementary

Input2 from workbook2

ID SchoolName

2 ABC School Academy

5 Philly North Elementary

I would like to update SchoolName field of workbook1 with SchoolName field of workbook2 by using common field ID between two workbooks.

Output expected:

ID SchoolName

1 LEHIGH VALLEY Elementary

2 ABC School Academy

3 Lansdale Penn High School

4 Wilmington Elementary Braddock

5 Philly North Elementary

Help

Accepted answers

estherb47

Hello.

A touch of creativity with joins works well here.

Here, I've joined on the ID field, and then Unioned the original list with the list that has the updated names (L and J outputs from the join). I manually configured the Union tool so that the right school name from the J output matches to the school name column. A select tool drops the extra column of information.

Replace School Names.yxmd

All comments

estherb47

Hello.

Replace School Names.yxmd

patrick_digan

@khap A slightly different approach would be to join on ID but only select the fields from your update file. Then union the Joined data with the data that didn't match and doesn't need updated.

Replace School Names.yxmd

khap

Thanks again. It works perfectly.

Quick Links

This months top contributors

LanisC 335

hhaigh1 280

erich_shiino 280

FláviaB 262

JORGE4900 235