We’ve extended Inspire Early Bird Pricing until March 1. Register now and enjoy 20% off conference passes and 10% off training passes. P.S. Don’t forget to bring friends! When you sign up for five or more tickets, you get an extra 20% discount on conference passes. Learn more now.

Alteryx Designer Desktop Discussions

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

Finding All Years in a Range

gbrouse
5 - Atom

Hi,

 

I have a start year variable (i.e. 2003) and and end year variable (i.e. 2006).

 

I am trying to create variables that say for example above, person A was a participant in 2003, 2004, 2005, 2006 (can be in row transactional or in new columns).

 

Anybody familiar with a formula to help me with this?

 

Thanks,

Greg

5 REPLIES 5
john_miller9
11 - Bolide

Greg - are you saying that the dates you are looking for may appear in rows or columns?  Do you have some sample data to share?  

gbrouse
5 - Atom

Thanks John.

 

What I am saying is I have a data set that has uniqueIDs per row.  One column is Begin Year and one column is End Year.  I'm looking to create additional data pieces to identify all year that person was a participant.

 

The data is confidential.

 

Example would be:

 

ID                 Begin Year           End Year 

12                 2003                     2008

 

What I need to do, is create additional data points, to show that ID 12 was a participant in 2003, 2004 ,2005, 2006, 2007 and 2008.

 

Thanks.

 

Claje
14 - Magnetar

Hi

Try the generate rows tool


Here's a screenshot of how to do this, creating a new field called Current Year:



CommunityGenerateRowsYears.PNG

gbrouse
5 - Atom

Claje - this is exactly what I was looking for, thank you so much!

ponraj
13 - Pulsar
 
Labels