Updating current field from another input

[khap]

Hi

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

[estherb47 · Accepted solution]

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.

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

[khap]

Thanks again. It works perfectly.