Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Announcement | We'll be doing maintenance during the next 2-3 hours, which may impact your experience. Thanks for your patience as we work on improving the community!
SOLVED

Updating current field from another input

Highlighted
Meteor

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

Highlighted
Magnetar
Magnetar

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.

 

 

 

image.png

Highlighted

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

Highlighted
Meteor

Thanks again. It works perfectly.

Labels