Navigation: Reference > Transforms >
Substitute column values into text.
To create SQL statements to insert 'Country', 'Year', 'Key' and 'Value' column values:
INSERT INTO mytable(Country,Year,Key,Value) VALUES ($(Country),$(Year),$(Key),$(Value));
•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.
•The transform is calculated every time:
oThe Evaluate button is pressed.
oThe Substitute transform item is unselected in the Center pane and script changes have been made without the Evaluate button being clicked.
oThe item upstream of it changes.
•If you want to carry out your transform across more than one dataset, you should Join them first.
•Warnings are shown in the Warnings tab for ambiguous column references.