Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

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
20 - Arcturus
20 - Arcturus

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

20211228-iamankurbisht.PNG

Qiu
20 - Arcturus
20 - Arcturus

@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
20 - Arcturus
20 - Arcturus

@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