Tables: Minimum Data in a Column

Use the Tables: Minimum Data in a Column to save the minimum value of a data table column to a field.

Use case

The Tables: Minimum Data in a Column action can find the smallest value. There are many uses cases for this action, including finding the lowest performing operation or the oldest customer request.

How to configure this action

This action will save the minimum value of different field types, like numbers or dates, and has specific behaviors for each field type:

  • If the column contains dates, the action will return the oldest date.
  • If the column contains text mixed with numbers, the action will ignore rows with text and return the minimum of the numerical values.
  • If the column contains all text, the value returned will be 0.

Fields for this action

  • Data table ID

    • 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 display name of the new column header, in the regular Column Header format
  • Output field name

    • Enter a name for the field in which the result should be saved

What will this output?

The minimum value from the column is returned to a field. The name of the output field will be the Output field name defined during configuration.

Output fields for this action

  • Output field name

    • The minimum value from the column.

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.