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

Determine if a condition exists within a selection of rows within a Data set

kpfjr
6 - Meteoroid

So I have a set of data with multiple dates of the same value and different overdue status' associated with those due dates. Similar to the screenshot below:

Alteryx question.JPG

 

What I want to do is just make one data point for each date that says if there is at least one report that is Overdue. For example, 1/1/19 would be considered Overdue since it has at least one report overdue whereas 1/2/19 has both reports submitted so it would not be overdue.

 

What would be the best way to go about creating this?

 

Thanks for your help!

 

2 REPLIES 2
jdunkerley79
ACE Emeritus
ACE Emeritus

I suggest:

2019-01-07_20-56-00.jpg

 

Start by making a list of dates which have an overdue entry then use a join multiple to link back to the input.

 

This will create a column of either Overdue or NULL for each day. You could then use a formula to reprocess that column.

kpfjr
6 - Meteoroid

Thanks jdunkerley79, this worked!

Labels