Tables: Get unique rows

Use this action to Identify all the unique values in one column of a data table, delete rows containing duplicate values, and save the result as a new data table

Use case

A common scenario involves following this action up with a Tables: Start Workflow for Each Row action on the resulting set of unique values, such as sending emails only to the unique individuals in a data table.

How to configure this action

Fields for this action

  • Data table

    • Select a table from a list of all tables available on your team. The list only includes tables you have permission to view.
      • You can also reference a table stored in a field. Change the left hand drop-down to Use table via field then select from any field that is part of the process. Learn more.
      • If necessary, you can enter the Table ID directly. Change the left hand drop-down to Use table by ID then enter the ID manually. Learn more.
  • Column name

    • The name of the column to filter for unique values.
  • Output field name

    • The name of the field in which the result should be saved. Can be in plain text or written in {{field-names}} format to reference resulting data table from a subsequent task.

What will this output?

This action creates a new data table with only the rows containing unique values. The table is saved to a field with the name defined in Output field name.

Get help with a problem or question

If something’s not working as expected, or you’re looking for suggestions, check through the options below.

Why do some column names not work?

Enclose individual column names and values in quotation marks (""), if they contain special characters like commas, leading/trailing whitespace, and newlines. For example:

  • If the column name is $Weekly Report,,,, enter the column name as "$Weekly Report,,,", with quotation marks.
  • If you want to use the field reference {{tablecolumn}} to dynamically reference the column name, enter it as "{{tablecolumn}}"

If the column name contains a quotation mark, escape each quotation mark with quotation marks, for example: if the column name is "Column name", enter it as """Column name""".

Sorry about that. What was the most unhelpful part?

Thanks for your feedback

We update the Help Center daily, so expect changes soon.

Link Copied

Paste this URL anywhere to link straight to the section.

Need more help?

If you're signed in to Catalytic Community, you can ask other users a question. You'll be redirected to Community where you can add more info.