Join Two Sets of Date

hyan028

Hi,

I have two separate date field like this:

6/30/2014

9/30/2014

12/31/2014

3/31/2015

6/30/2015

10/26/2014

1/15/2015

Then I want to join the two based on whether the B date is within the range of A. So the result should be like:

A B

6/30/2014

9/30/2014

12/31/2014 10/26/2014

3/31/2015 1/15/2015

6/30/2015

How can I make this happen????

Best,

Blake

Join

Accepted answers

kat

Hi @hyan028

Here's a solution for you.

hope this helps

Kat

DateJoin.yxmd

BenMoss

There is a weekly challenge that would definitely help with your learning of this problem, the 'join to range' problem, although slightly different would allow you to understand how this could work...

https://community.alteryx.com/t5/Weekly-Challenge/Challenge-1-Join-to-Range/td-p/36621

Personally I would approach this in a different way to @kat which is to use the generate rows.

Example attached.

Ben

JoinDate.yxmd

All comments

kat

Hi @hyan028

Started to build it for you, but was then wondering, what would happen if more than one date fits in a range?

Cheers

Kat

hyan028

Hey @kat,

Thanks for the question. I thought about it too. Based on my understanding of the nature of my data, it shouldn't happen. So it will be only one date fits in a range.

Best,

Blake

kat

Hi @hyan028

Here's a solution for you.

hope this helps

Kat

DateJoin.yxmd

BenMoss

https://community.alteryx.com/t5/Weekly-Challenge/Challenge-1-Join-to-Range/td-p/36621

Personally I would approach this in a different way to @kat which is to use the generate rows.

Example attached.

Ben

JoinDate.yxmd

hyan028

Thanks @BenMoss, it solves the problem too. I'm still weighing the option on embedding which version to my current workflow, but the solution is great.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703