How to update data in a input data table from another table based on column match

[Parthasarathi]

Hi All,

How to update data in a input data table from another table based on column match. 

Input Data 1:

Name	City
A	City1
B	City2
C
D
E	City5

Input Data 2:

Name	City
C	City3
D	City4

Expected output based on the 'Name' match

Name	City
A	City1
B	City2
C	City3
D	City4
E	City5

[Robin_McIntosh]

Use a Join then Union the L & J outputs.

[grazitti_sapna · Accepted solution]

@Parthasarathi , you can achieve this using Join on the basis of Name and then you Union the records by position. Here is the sample workflow.