Developer Transformation Guide

10.5
- 10.5.2
- 10.4.1
- 10.4.0

Back Next

String Substitution

Use string variables to replace components of query statements. For example, you can use the string variable to replace the table name in a query. Or, you can substitute the column names in a SELECT statement.

To substitute the table name, configure an input port to receive the table name from each input row. In the SQL Editor, select the port from the

String Substitution

list of ports. The Developer tool identifies the input port by name in the query and encloses the name with the tilde (~).

The following query contains a string variable, ~Table_Port~:

SELECT Emp_ID, Address from ~Table_Port~ where Dept = ‘HR’

The source might pass the following values to the

Table_Port

column:

Table_Port
Employees_USA
Employees_England
Employees_Australia

The Data Integration Service replaces the ~Table_Port~ variable with the table name value in the input port:

SELECT Emp_ID, Address from Employees_USA where Dept = ‘HR’
SELECT Emp_ID, Address from Employees_England where Dept = ‘HR’
SELECT Emp_ID, Address from Employees_Australia where Dept = ‘HR’

Rename Saved Search

Table of Contents

Developer Transformation Guide

Developer Transformation Guide

String Substitution

String Substitution