How can Alteryx help in tracking deadlines?

[Rupal03]

I want to prepare a monitoring schedule for my  FDs and also want to track its renewal deadline. How can I achieve it? 

I am also attaching a dummy data set

[sparksun]

Surely Alteryx can do it,but It depends how you want to track those renewal deadline.

[Rupal03]

So I want to get a notification whenever the deadline is approaching so that I don't miss any compliance  

[danilang · Accepted solution]

Hi @Rupal03 

You can use something like this

The Reminder Interval Text Input tool has the number of lead days.  Append this to the input data and use a formula to only pass the dates where the difference between that date and today is less than the lead days.  I also included a clause to ignore renewal before today.  This is assuming that you'll actually get to them before the renewal date and once renewed, the renewal date will be updated.

Change the Browse to an email tool and schedule this daily. 

Dan 

[Christina_H]

Are you working with just Alteryx Designer?  Designer will only be able to notify you of things when a workflow is run manually.  You would need a server or scheduler licence for this to happen automatically.

You could set up a workflow something like the attached, which will error to notify you of dates within the next month each time it runs.  The browse shows the records.