Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
解決済み

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
メテオロイド

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件の返信5
binuacs
アルクトゥルス

@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
メテオロイド

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

ラベル