Substitute

<< Click to Display Table of Contents >>

Navigation:  Reference > Transforms >

Substitute

Description

Substitute column values into text.

 

Example

Create an SQL statement to insert 'date', 'cases', 'deaths' and 'country' values into 'mytable':

 

 

how to convert CSV to SQL example

 

Inputs

One.

 

Options

Enter your substitution script into the Substitution script field.

Select a column from Insert variable to add that column variable into the Substitution script field at the current cursor position.

Click the Evaluate button to evaluate your script over every row and show any errors (only available if Run>Auto Run is checked).

 

Notes

The new column is added at the right end. You can change the column order with Reorder Cols and the column name with Rename Cols.

If you want to carry out your transform across more than one dataset, you should Join them first.

If you need to do something more complex than this transform allows, try the Javascript transform.

Warnings are shown in the Warnings tab for ambiguous column references.