Transforming data - bonus lesson

Format numbers

When working with partners and external systems, it’s common to receive data that doesn’t quite match the format you require. The Format numbers step transforms values into whatever custom numeric value you require. 

How to use the step

  1. Drag a Format numbers step onto the canvas. 
  2. Select the columns you want to reformat. 
  3. Specify an updated format for the column values. 
  4. Click the three dots next to your format selection to access advanced settings such as number of decimal places, currency symbols, and rounding options. 

Pro tip

  • Unlike traditional spreadsheets that require data types to be specified per column, Parabola handles this automatically.
  • If you ever run into an Invalid Format issue while using an Add math column step (which we’ll go over in the next lesson), use the Format numbers step before the calculation to ensure the data is properly formatted.

Visit our support docs to learn more about the step. 

Next lesson