Filter on Numerical Range

Description

This activity filters the values in the specified columns based on a defined numerical range.

Input

Data only

Output

Transformed data

Configuration Fields

• Columns
  Specifies the columns to filter based on range.

• Minimum Value
  Defines the minimum value for filtering.

• Maximum Value
  Defines the maximum value for filtering.

• 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.

• FlagRows Action (Rendered only when the action is Flag Rows)
  Defines the pattern to flag rows

  • Flag if Any Column Matches Flags rows if any specified column value matches.
  • Flag if All Columns Match Flags rows if all specified column values match.

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

---

Sample Input Data

column_1	column_2
5	data1
10	data2
25	data3
50	data4
75	data5

---

Sample Configuration

---

Sample Output 1 (Keep Matching Rows Action)

column_1	column_2
10	data2
25	data3
50	data4

---

Sample Output 2 (Remove Matching Rows Action)

column_1	column_2
5	data1
75	data5

---

Sample Output 3 (Flag Rows Action Flag if Any Column Matches)

column_1	column_2	range_flag
5	data1	0
10	data2	1
25	data3	1
50	data4	1
75	data5	0

---

Sample Output 4 (Clear Content of Matching Cells)

column_1	column_2
5	data1
	data2
	data3
	data4
75	data5

---

Sample Output 5 (Clear Content of Non-Matching Cells)

column_1	column_2
	data1
10	data2
25	data3
50	data4
	data5