Join on different data sets

[DS1810]

Hello,

I have a data sets with different "Location" codes, and for each location, it has different "IJ dates" under each location.

The date ranges from 05/01/2021 to 05/05/2021. I would like to join the two data sets and find out those missing dates for each hotel.

So ideally the outcome should be like this. Since BAKPH does not have 05/04/2021, and TYOCT does not have 05/01/2021 - 05/04/2021... and so on.

Just would like to see if anyone can help, thank you!!! 😁

[ncrlelia · Accepted solution]

Hi @DS1810,

Please see attached my suggested solution.

Hope it helps.

Cheers,

Lelia

[Laurap1228 · Accepted solution]

Will this solution work for you?

[binay2448 · Accepted solution]

Here is my solution...

[DS1810]

Dear,

I tried it on the full data sets but it's giving me some errors. I have attached the complete data here (if not troubling you too much).

Basically what I did in the sample data before is that I use the "Unique" tool to exact all the dates. In the complete data sets as you can see, after I exact all the unique dates, it's from 05/01 - 05/31. However then i tried to input the data into your workflow, it's giving me error saying below. Not quite sure what is going wrong.

[Laurap1228]

HI @DS1810 

Try to modify the Append tool settings to Allow All Appends

[DS1810]

OMG It is working!!! It's amazing!!! Thank you so much!!!😁

[DS1810]

It works, THANK YOU!!

[DS1810]

THANK YOU Lelia!!