Time-Based Filtering

[akvsachin]

Hi Community, 

Problem Statement:

You are building an Alteryx workflow scheduled to run twice a day (10 AM and 4 PM), which must fetch records based on dynamic time windows defined by business rules:

Business Logic for Data Inclusion:

• The 10 AM run should include records updated since the previous day’s 4 PM run.

• The 4 PM run should include records updated since the same day’s 10 AM run.

• On Monday at 10 AM, it should include records updated since Friday 4 PM.

What approach would you suggest ?

Using a formula tool to create Run Start Time and Run End Time columns, and filtering accordingly.

Or some other way ?

[aatalai · Accepted solution]

@akvsachin  I did this via calculating the desired filter time based on start time, then appending it to the data and then filtering, calculated the filter times based on day, time, it started on and then took it from there subtracting the relevant hour gap. Please let me know how you get on (this could of been done in one filter tool, but that would of resulted in a significantly more complex filter statement