Reference Row filter

Polite123

Hi Team,

Need some quick help for below issue.

Input 1:

Name	Age
A	1
B	2
C	3
D	4
E	5

Input 2:

Name	Age
A	20
B	30
C	40
D	31

Output:

Input1 and 2 will be compared and Input 2 will be used as reference table and input 1 will be replaced with the values of input 2 and non matching contents of input 1 will be retained.

Name	Age
A	20
B	30
C	40
D	31
E	5

Any help would be highly appreciated.

Thanks!!!

Sebastiaandb

Hi @Polite123 ,

Here you go!

Let me know if this is what you're searching for 🙂

Greetings,

Seb

Retaining.yxmd