Filter on Falsy Values

Description

This activity filters the values in the columns based on the selected falsie values. Falsie values are a set of predefined values including False, 0, NaN, empty string, and undefined.

Input

Data Only

Output

Transformed Data

Configuration Fields

• Column Specifies the column to filter based on the falsie value.
• Falsy Values Defines the falsie values to be filtered (False, 0, NaN, empty string, undefined).
• Flag Rows Column Name The name of the new flag column. This is rendered only when the action is Flag Rows.
• Actions Specifies the actions for rows containing falsie values
  1. Keep Matching Rows Selects only the matching rows.
  2. Remove Matching Rows Removes the matching rows from the data.
  3. Flag Rows Flags the rows that contain falsie values (1 for flagged, 0 for non-flagged).

Sample Input 1

column_name	other_column
1	data
0	more data
NaN	test
	example
2	content

Sample Configuration 1

Sample Output 1 (Flag Rows Action)

column_name	other_column	falsy_flag
1	data	0
0	more data	1
NaN	test	1
	example	0
2	content	0

Sample Input 2

column_name	other_column
1	data
0	more data
NaN	test
	example
2	content

Sample Configuration 2

Sample Output 2

column_name	other_column
1	data
2	content