Subtract tables

Subtraction feature allows you to perform set difference operation on two tables. You will select a key column in both tables, which will be used for comparing the two rows.

1 min read - Start now

Open the transform menu

To subtract from two tables, click the gear icon at the top right corner of the page and select “Transform” from the dropdown menu.

Select subtract

A Popup window will appear. Select “Subtract” and click Next. Then, Select the table that you will subtracting from in “Select Top Table” and the table with values that you want to subtract in “Select Bottom Table.”

In “Select Key Column” select the column that will decide if the rows are the same.

After clicking Start, the Top Table will now only have values that are not included in the Bottom Table.