Filter on Values

Description

This activity filters data based on specified values, applying transformations as defined by the user. It allows for flexible filtering through various matching and normalization modes.

Input

Data only

Output

Transformed data

Configuration Fields

Columns Specifies the columns to which the value filter should be applied. Value Defines the specific value used to filter rows. Matching Mode Determines how values are matched during filtering. Options include

• Complete Value

• Substring

• Regex (matches with regular expression pattern) Normalization Mode Defines how to normalize values before filtering. Options include

• Case Sensitive

• Case Insensitive

• Accent-Insensitive Flag Rows Action Specifies a pattern to flag rows (rendered only when ‘Flag Rows’ is enabled).

• Flag if any column matches

• flag only if all column matches

Flag Rows Column Name Defines the name of the new flag column (rendered only when ‘Flag Rows’ is enabled). Flag Rows (Switch) If enabled, flags the rows with 0 or 1 based on the specified pattern.

Sample Input

Product ID	Product Name	Category	Price
101	Laptop	Electronics	75000
102	Phone	Electronics	50000
103	Chair	Furniture	3000

Sample Configuration

“

Sample Output

Product ID	Product Name	Category	Price	IsElectronics
101	Laptop	Electronics	75000	1
102	Phone	Electronics	50000	1
103	Chair	Furniture	3000	0

Sample Output (flag rows false)(keeps only matching rows having values)

Product ID	Product Name	Category	Price
101	Laptop	Electronics	75000
102	Phone	Electronics	50000