Skip to Content
DocsOperationsTransform

Transform

InfoLink provides a universal operation, called Transform, that allows the user to implement any transformation in the query language supported by the data source. For example, you can use transform to execute a SQL query in a relational database source. Or execute SOQL in Salesforce. It must be a query: any statement that returns a result, not update or DDL statement. For update and DDL statements use RunSourceScript operation.

Parameters:

  • Source: name of the source in which query will be executed

  • Query: any query statement supported by the source. The result of the query forms the target table.

  • Target source, space and table: specifies the location of the result table. Target source can be different from Source.

  • Standardize column names: if checked, the column names of the target table will be normalized - converted low case, spaces replaced with “_”.

  • Limit: you can limit the result to only N first records.

  • Return result, result name: are used to return results via API. If Return result is checked the target table will not be create. Instead the result of the query will be added to result sets returned via API. Result name specifies the name of the result set. If the result name is empty then the name is null.

When the source is Microsoft SQL Server (MSSQLSource) and you use a complex query (especially with nested queries), InfoLink can have troubles to compile the SQL statement from your query resulting in an error “Incorrect syntax near the keyword ‘into’”. To fix this issue, provide a hint to InfoLink on where the into statement must be inserted in your query by adding $into-statement$ as shown in the example below:

WITH t AS
(
select * from op_load_us_100
)
select * $into-statement$ from t
Last updated on
StopJobTruncate