Compare columns in the Filter Pipeline step

Data Pipeline

If you only want to return rows where one column has a certain relationship (greater than, less than, etc.) to another column, use the Filter step to compare these columns.

In this example, we want to return only rows where our Adwords sales are higher than our Print sales. Here’s the chart we’re working with:

Compare columns in filter Pipeline step

We’ll add a Filter Rows step in the Pipeline (Add Step > Filter Rows) with the following settings:

Compare step 1

As you can see, rows where Print sales were greater than Adwords sales are removed.

Compare filter Pipeline steps 2

Related Data Pipeline Help Articles

See more