Transformations

Back Next

Substituting the table name in a string

You can use a partial query to substitute the table name. To substitute the table name, configure an input field to receive the table name from each input row. Identify the input field by name in the query and enclose the name with tilde characters (

For example, the following dynamic query contains a string variable,

~Table_Field~

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

The source might pass the following values to the Table_Field column:

Table_Field
Employees_USA
Employees_England
Employees_Australia

Data Integration

replaces the ~Table_Field~ variable with the table name in the input field:

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

Transformations

Transformations

Substituting the table name in a string

Substituting the table name in a string