Transformation Components

start at - timezone information

In my start component I am exporting "started to" a timestamp variable. Subsequently in an API component in Advanced mode my SQL Query has: ... cast('${timestamp}' as timestamp) as thetime...

Pass value from Transformation to Orchestration Component

I would like a transformation component to return some manner of value to its parent orchestration component. To my understanding, transformation jobs cannot affect variable values (unless I'm mistaken); are...

Pick aggregated value using Aggregate component and use it as a new expression

I am trying to take max value of a column based on an aggregated column and apply it as a new column (static value) across all records excluding aggregation. I...

Except Component Problems

This has three parts: 1) The actual description of what the Except component does seems to be backwards. What the help says is "Compares two input flows and outputs any...

Can I Write to an Oracle database?

Can i write the result of a Transformation to an on-premise Oracle database? A more general question is what are the possible targets of write the output of a transformation?...

Store query result to variable

Is there any way to store query result to variable in Transformation job ? I want to save single output value from SQL component to variable and the use it...

extract date from timestamp

the following query syntax is incorrect: select *, 'Y' as ISACTIVE from "Patient" where date("LastUpdated") in (select date(max("LastUpdated")) from "Patient") It keeps saying invalid date identifier. Please help Thanks,

Netezza to Snowflake

Hello! Can we use Matillion to convert Netezza to Snowflake? Couldn't find any obvious indications of this, at least as far as named source components were concerned, so just wanted...

Table Update

I'm trying to understand the Table Update component - the online support doc seems to differ from the latest version of the component. I would like to update a table...

Filter value

how to use - convert_timezone('UTC',CURRENT_TIMESTAMP) in filter value