Compare Two Dates from Different Inputs

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.

Date Time

Accepted answers

RolandSchubert

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

All comments

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

compare_dates.yxmd

RolandSchubert

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

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 🙂

compare_dates.yxmd

HRivera

Hi @RolandSchubert,

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

Thanks!

Quick Links

This months top contributors

AkimasaKajitani 387

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335