Update Values

Write one value into a column. Change every row, or only the rows you choose.

What it does

Update Values writes a value into a column. The value can be text you type. It can also be a formula built from other columns. You pick the target column at the bottom of the panel, under Apply results into.

Set a value

This example works on a support ticket export.

  1. Type update values in the Search transforms box, in the Pipeline panel.
  2. Select Update Values in the results. The panel opens below the grid.
  3. Type your value in the Value box. For example, type Escalated.
  4. Go to Apply results into.
  5. Leave the first button selected. It reads New Column (Text).
  6. Type a name in New Column Name. For example, type review_state.
  7. Click Apply.

The grid updates at once. The step appears in your pipeline. You can edit or delete it later.

Value mode and Expression mode

A small switch sits to the right of the Value label. It has two settings.

  • Value gives you a plain box. Text targets get a text box. Number targets get a number box. Date targets get a date picker.
  • Expression gives you a formula box. Write column names in double quotes. Examples: UPPER("owner") and "hours" * 60.

Expression mode also shows a Generate expression from intent helper. That helper needs an API key in Settings.

Where the result goes

Apply results into has two buttons.

  • New Column (Text) adds a column at the end of the table. Three small buttons appear beside the name box. T means text, # means number, and D means date. The button label follows your choice.
  • Existing Column shows a list of every column in the table. Pick one, and this step overwrites it.

An existing column keeps its type

This step never changes the type of a column you overwrite. A number column stays a number column. Your value is converted to that type first. A value that cannot convert becomes empty.

Example: you type unknown into a number column. Every updated row goes empty instead. Write into a new text column when you need words in a number column.

Change only some rows

  1. Click Add Condition.
  2. Stay on the Visual tab, or open the SQL Expression tab.
  3. Build your test, for example priority is P1.
  4. Click + And or + Or to add more tests. Click Nested group to group them.
  5. Click Apply Condition, then click Apply.

Rows that do not match keep their old value. In a new column, those rows stay empty.

For SQL users

A new text column with a condition runs as:

SELECT *, CASE WHEN ("priority" = 'P1') THEN 'Escalated' ELSE NULL END AS "review_state" FROM data
Try Update Values with sample data →

Related Operations