Alteryx Designer Desktop Discussions

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

2 i/ps, pick the missing records by date in i/p1 vs i/p2, from i/p 2 and append to i/p 1.

i_m_AB
6 - Meteoroid

sharing dummy data, Right now I am manually filtering the missing dates from 2nd input. I want to automatically pick the missing dates record from input 2 and append them to input 1.

5 REPLIES 5
binuacs
20 - Arcturus

@i_m_AB 

 

binuacs_0-1640766202582.png

 

Qiu
21 - Polaris
21 - Polaris

@i_m_AB 
We can do this by Join and Union tools.

20211228-iamankurbisht.PNG

Qiu
21 - Polaris
21 - Polaris

@binuacs 
Beat me again. 😁

i_m_AB
6 - Meteoroid

Thank you both, I believe I can use your suggestions in making workflow more dynamic. You were both a huge help.

Qiu
21 - Polaris
21 - Polaris

@i_m_AB 
Glad to help and would appreciate it if you could mark the solution from I and @binuacs as accept if you find them helpful. 😂

Labels