Filter on Date Range

Description

This activity filters the values in the specified column based on a defined date range.

Input

Data only

Output

Transformed data

Configuration Fields

1. Column
   Specifies the column to filter based on the date range.

2. Minimum Value
   Defines the minimum value (date) for filtering.

3. Maximum Value Defines the maximum value (date) for filtering.

4. Actions
   Specifies the actions for rows outside the range

   • Keep Matching Rows Selects only rows within the range.
   • Remove Matching Rows Removes rows within the range.
   • Flag Rows Flags rows within the range (1 for match, 0 otherwise).
   • Clear Content of Matching Cells Clears values within the range.
   • Clear Content of Non-Matching Cells Clears values outside the range.

5. Flag Rows Column Name Name of the new flag column (rendered only when the action is Flag Rows).

Sample Input

date_column	value
2024-12-31	100
2025-01-01	200
2025-01-10	300
2025-01-15	400
2025-01-20	500

Sample Configuration

Sample Output

date_column	value
2025-01-01	200
2025-01-10	300
2025-01-15	400