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 2 tables

Carolyne
8 - Asteroid

Question:

 

I have 2 tables. One shows eligible members (active members) and table b shows dis-enrolled members

Table A:

 

Member #

Effective Date

603

1/1/2016

604

3/14/2018

 

Table B:

Member #

Effective Date

Dis-enroll_Date

604

3/14/2018

9/12/2018

 

The output, should be:

 

Member #

Effective Date

Month

Year

Disenroll_Date

Dis-enroll Month

Dis-enroll Year

Active

603

1/1/2016

Jan

2016

 

 

 

Yes

604

3/14/2018

March

2018

9/12/2018

September

2018

No

 

Thanks for all your help.

3 REPLIES 3
tcroberts
12 - Quasar

Here's a sample workflow:

 

joindisenrolled_members.PNG

 

Alteryx only understands the 'yyyy-mm-dd' format for dates, so I've converted into those, parsed out the desired bits, and then removed all unnecessary columns.

 

Let me know if this helps,

 

Cheers!

ponraj
13 - Pulsar

Here is the sample workflow for your case. Hope this is helpful. 

 

WorkflowWorkflowResultsResults

Carolyne
8 - Asteroid

Thank you! 

Labels