Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
Start Free Trial

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
21 - Polaris

@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
Top Solution Authors