Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Reference Row filter

Polite123
8 - Asteroid

Hi Team,

 

Need some quick help for below issue.

 

Input 1:

 

 

Name Age
A1
B2
C3
D4
E5

 

Input 2:

 

Name Age
A20
B30
C40
D31

 

 

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
A20
B30
C40
D31
E5

 

Any help would be highly appreciated.

 

 

Thanks!!!

 

 

 

1 REPLY 1
Sebastiaandb
12 - Quasar

Hi @Polite123 ,

 

Here you go!

 

Sebastiaandb_0-1639118912885.png

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

 

Greetings,

 

Seb

Labels
Top Solution Authors