Compare Two Dates from Different Inputs

[HRivera]

Hi All, 

Asking for your help regarding this one. I'm trying to compare two dates from different sources one serves as the input one serves as a reference. If the particular date is found on the reference, the data will be deleted on the input. Input - "New Date" Reference - "Holidays"

 

Appreciate your help.

Thanks.

[afv2688]

Hello @HRivera ,

Are you looking for something like this?

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Regards

[RolandSchubert · Accepted solution]

Hi @HRivera ,

use a Join tool and join on New Date = Holidays. The left output anchor will return the "not-holiday days".

Hope this is helpful.

Best,

Roland

[HRivera]

Hi @afv2688, 

Yes! I'm looking for something like this but I have a question.. What if I will have hundred thousands or millions rows of dates, and I shall append all holidays date per day, the file size will be big..

Let me know your thoughts.

Thanks! 

[afv2688]

Then you can use this 🙂

[HRivera]

Hi @RolandSchubert, 

Wow! This is amazing. Will try and get back to you. Will let you know if it worked. 

Thanks!