Skip to main content

​
Input/output

Our input data shows how many items we sold on a given day.
Input data showing daily item sales spread across multiple columns
We can use this step to produce an output with a new column at the right side, called ‘Most Sold in a Day,’ which contains the maximum value in each row.
Output data with a new 'Most Sold in a Day' column appended showing the max value across each row

​
Default settings

This step will automatically generate an ‘Untitled’ column after data is connected to it.
Default settings panel auto-generating an Untitled column once data is connected

​
Custom settings

In the left-side toolbar, first choose in the ‘Operation’ dropdown menu whether our new column should show the ‘Min’ or the ‘Max’.
Custom settings panel showing the Operation dropdown with Min and Max options
Then choose the columns to operate on by selecting values under ‘Range Begin’ and ‘Range End’.
Custom settings panel showing Range Begin and Range End column selectors that define the columns to evaluate
After this, name your new column and click ‘Show updated results’ at the bottom to save.
Custom settings panel showing the new column name field and the Show updated results button
There is an advanced settings menu that you can expand. By default, the box is checked to ‘Prefer numbers’ when running your operation. You can deselect this option, but we recommend leaving it on.
Advanced settings menu showing the 'Prefer numbers' checkbox option toggled on
Your table will now have a column appended, displaying the minimum or maximum value per row, within the columns in your selected range.
Last modified on May 18, 2026