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

Question

Hi All,

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

Input Data 1:

NameCityACity1BCity2C D ECity5

Input Data 2:

NameCityCCity3DCity4

Expected output based on the 'Name' match

NameCityACity1BCity2CCity3DCity4ECity5

grazitti_sapna · Accepted Answer

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