filter

filter

DomoDataflow Filter Actions

Filter and data cleaning actions in Magic ETL v2. These correspond to the "Filter" category in the Domo ETL UI sidebar.

DomoDataflow_Action_Filter dataclass

DomoDataflow_Action_Filter(
    id: str,
    action_type: str = None,
    tile_type: str | None = None,
    name: str = None,
    depends_on: list[str] = None,
    disabled: bool = False,
    gui: dict = None,
    settings: dict = None,
    raw: dict = None,
    parent_actions: list[DomoDataflow_Action_Base] = None,
    filter_list: list[dict] = None,
    input: str = None,
    tables: list[dict] = None,
)

Bases: DomoDataflow_Action_Base

Filter action - filters rows based on conditions.

Attributes:

Name	Type	Description
filter_list	list[dict]	List of filter conditions

Example

filter_action = dataflow.get_action_objects("Filter")[0] print(filter_action.filter_list)

column_relationships property

column_relationships: set[ColumnRelationship]

Column relationships for Filter tile.

Filtered columns → INDIRECT/FILTER All other columns → DIRECT/IDENTITY (passthrough)

DomoDataflow_Action_Unique dataclass

DomoDataflow_Action_Unique(
    id: str,
    action_type: str = None,
    tile_type: str | None = None,
    name: str = None,
    depends_on: list[str] = None,
    disabled: bool = False,
    gui: dict = None,
    settings: dict = None,
    raw: dict = None,
    parent_actions: list[DomoDataflow_Action_Base] = None,
    fields: list[dict] = None,
    count_rows: bool = False,
    input: str = None,
    tables: list[dict] = None,
)

Bases: DomoDataflow_Action_Base

Unique action - removes duplicate rows.

Also known as "Remove Duplicates" in the Magic ETL UI.

Attributes:

Name	Type	Description
fields	list[dict]	Columns to consider for uniqueness
count_rows	bool	Whether to add a count column

Example

unique_action = dataflow.get_action_objects("Unique")[0] print(f"Deduping on: {unique_action.dedup_columns}")

column_relationships property

column_relationships: set[ColumnRelationship]

Column relationships for Unique (Remove Duplicates) tile.

Dedup columns → INDIRECT/GROUP_BY (used for deduplication)

dedup_columns property

dedup_columns: list[str]

Get list of columns used for deduplication.