Join 2 tables

[Carolyne]

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.

[tcroberts · Accepted solution]

Here's a sample workflow:

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 · Accepted solution]

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

WorkflowResults

[Carolyne]

Thank you!