Alteryx Designer Cloud Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Cloud.
SOLVED

How to marge two data sets?

TrifactaUsers
10 - Fireball

Hi everyone,

 

I have two time series data sets. The first one contains all the historical values and need to be updated. The second data set contains new values as well as some historical values (corrections) that differ from the historical values contained in the first data set. The idea is to update the first data set with the new values and to replace the "new" historical values contained in the first data set (you can think of it as a correction made in a second moment).

 

How can I achieve that? How can I replace the value contained in the first data set with the ones in the second data set?

 

To give you an idea, I would like to drop all the rows of the first data set whose date is contained also in the second data set..

 

Thank you :)

10 REPLIES 10
Trifacta_Alumni
Alteryx Alumni (Retired)

My pleasure @Daniel Zito?, glad it works! I guess you selected your comment as Best Answer :-D but no worries :)