Join on different data sets

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!!! 😁

Datasets

Developer

Developer Tools

Output

Fuzzy Match

Join

In Database

Google Analytics

In-Database

Accepted answers

Please see attached my suggested solution.

Hope it helps.

Cheers,

Lelia

New Workflow.yxmd

Will this solution work for you?

Sample Solution.yxmd

Here is my solution...

Join on different data sets.yxmd

All comments

Please see attached my suggested solution.

Hope it helps.

Cheers,

Lelia

New Workflow.yxmd

Will this solution work for you?

Sample Solution.yxmd

Here is my solution...

Join on different data sets.yxmd

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.

DATA LISTING NEW - ALTERYX.xlsx

It works, THANK YOU!!

THANK YOU Lelia!!

Quick Links

Tags

This months top contributors

atcodedog05 19458

Qiu 15866

MarqueeCrew 13708

apathetichell 13703