Filter on Formula

Description

The Filter on Formula activity filters rows based on formulas you define. It checks each row using conditions like [column1]/[column2] > 10, where [Column1] refers to a value in that row. Based on the formula result, it can perform different actions:

• Keep only matching rows
• Remove matching rows
• Clear matching or non-matching cell values
• Flag rows by marking a new column with 1 or 0

Example: a sales dataset can use the formula [Amount]/[Boxes] > 10 to filter high-value shipments. Matching rows are retained using the KeepMatchingRowsOnly action.

Input

• Data – Required

Output

Output Type	Format	Notes
Data	Tabular	Returns filtered, flagged, or updated data depending on action configured

Configuration Fields

Field Name	Description
Column Map	A list of column-to-formula mappings. Each mapping applies a logical expression to a specific column.
Actions	The action applied to matching or non-matching rows. Supported actions: KeepMatchingRowsOnly RemoveMatchingRows ClearContentOfMatchingCells ClearContentOfNonMatchingCells FlagRows
Flag Column Name	(Optional) Required only when using FlagRows action. Specifies the column used to flag the row with 1 (match) or 0 (non-match).

Sample Input

Product	Amount	Boxes	Region
A	1200	10	North
B	800	5	South
C	90	10	East
D	300	40	West
E	500	20	Central

Sample Configuration

      <table>
        <tr>
          <td><b>Column Map</b></td>
          <td>
            <table>
             <tr>
                <td><b>Column</td>
                <td><b>Formula</td>
              </tr>
              <tr>
                <td>Amount</td>
                <td>[Amount] / [Boxes] &gt; 10</td>
              </tr>
            </table>
          </td>
        </tr>
        <tr>
          <td><b>Actions</b></td>
          <td>Keep Matching Rows Only</td>
        </tr>
      </table>

Sample Output

Product	Amount	Boxes	Region
A	1200	10	North
B	800	5	South