Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

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

Multi Row Formula - IF between dates and refer back to a specific row

Dee_Evans
5 - Atom

I have a list of workspaces:

- ID's that equal 22 are support episodes

- ID's between 23-30 are updates

 

This is my input: 

Workspace Start.jpg

 

I need to link the updates to the support episode based on the following conditions: 

- Person ID to match 

- Workspace ID != 22 

- start date is => the start date of Workspace ID 22 row 

 

I then want to add an additional column for Workspace Group to show the Workspace Ref is for all lines within the group. 

 

My desired output is: 

Workspace Outcome.jpg

 

 

 

 

 

 

 

 

Can this be done with a Multi Row Formula? 

 

1 REPLY 1
RaphaelSilva
9 - Comet

Please see sample workflow attached
On your sample data, there was an easier way to do it with less rules, as are expecting your data structure to change?
Because if it changes, is better to work on having the data on that structure before applying multirow formula, otherwise it might also not work in another sort order.

 

Labels