A common challenge when working with customer source data is dealing with old and obsolete source data that you ingest with the data you want. But preprocessing your source data takes extra time and effort.

With Customer Insights - Data, you can apply row filters directly to any source table you ingest. This filter feature reduces the data scope to just what you need. You apply filters one time on the Tables page. The Tables page displays source tables on their own tab. This tab separates source tables from the output tables that Customer Insights creates. Select the row filter link next to any table to set the filters you want.

Add filters on the Tables page

To optimize processing speed, Spark filters data during processing for unification, segments, measures, activities, and models. When you download data from the Tables page, you get the full dataset without filters.

This feature offers key benefits:

Faster processing: By removing unwanted rows, the system skips unnecessary data and cuts down processing time.
Better output data: When you remove unnecessary data from the output, you make it easier for consumers to use the data without needing to exclude unwanted data.

Limitation

The condition Is any of {list of values} works only for string data.

Row filters support multiple conditions and operators