Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Join on different data sets

DS1810
6 - Meteoroid

Hello,

 

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

 

DS1810_0-1629427144969.png

 

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.

 

DS1810_1-1629427215280.png

 

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.

 

DS1810_2-1629427236309.png

 

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

8 REPLIES 8
ncrlelia
11 - Bolide

Hi @DS1810,

 

Please see attached my suggested solution.

Hope it helps.

 

Cheers,

Lelia

Laurap1228
11 - Bolide

Will this solution work for you?

Laurap1228_0-1629428659279.png

 

binay2448
11 - Bolide

Here is my solution...

DS1810
6 - Meteoroid

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.

 

DS1810_0-1629430014166.png

 

Laurap1228
11 - Bolide

HI @DS1810 

 

Try to modify the Append tool settings to Allow All Appends

 

Laurap1228_0-1629430268929.png

 

DS1810
6 - Meteoroid

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

DS1810
6 - Meteoroid

It works, THANK YOU!!

DS1810
6 - Meteoroid

THANK YOU Lelia!!

Labels