Alteryx Designer Desktop Discussions

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

Pull in Result from range of data in seperate input data

Jon12
6 - Meteoroid

Hi, I have two sets of input data.  The first data set has a column with settlement dates as shown in the first grab below.  The second is assigning date ranges to specified periods as shown in the second grab below. I am trying to run a formula so that if the STTL_DATE is >= Period Begin and <= Period End that it pulls into a new column with the corresponding Period field from the second set.  Most solutions I am seeing call for a join tool but I cannot get this to work as there are no fields that join since I am looking for between a set of values.  I'm still learning and hope to give back once I do, thank so much!

 

STTL_DATE
10/30/2020
12/15/2020
12/20/2020
09/01/2020

 

PeriodPeriod BeginPeriod End
P7 20208/1/20208/28/2020
P8 20208/29/20209/25/2020
P9 20209/26/202010/30/2020
P11 202011/28/202112/25/2021
P10 202010/31/202011/27/2020
P11 202011/28/202012/25/2020
2 REPLIES 2
Luke_C
17 - Castor

@Jon12 

 

You can use a generate rows tool to create a record for each day in the period, and then join that up with the dates in your first table to figure out what period they are in. See attached example. 

Jon12
6 - Meteoroid

Thank you!   This looks to have worked very well.  I appreciate your help

Labels