Transformation Components

Export row count

Example. I want to know the total number of rows in a physical table after my transformations is done. Iam using a table update component where I export the row...

Global Variable in Calculatr

Hi, we're running Matillion ETL for Redshift Version: 1.24.6 (build 55) and I'm trying to use a variable in the expression box of a Calculator component. i defined a simple...

pattern for incremental fact table load by day

I would like to load a fact table 1 day at a time, from the latest day of data in the fact table until the current day. What is the...

URL does not point to an accessible S3 bucket.

Experiencing issue in accessing the s3 URL. when i enter the s3 URL, i get an error "That URL does not point to an accessible S3 bucket." Not sure what's...

Include task information in SNS message

Hi. Is it possible to include systeminformation or taskinforamtion in the SNS message? Perhaps if a component or transformation job fails, the error message in the tasks message flow could...

How do I replace a value in a string?

Is there a transformation component that can be used to replace a value in a string? Say I have a number provided with a comma instead of a decimal point...

Detect Changes component deliveres "ERROR: could not devise a query plan for the given query"

I want to compare 2 tables based on a varchar column using the Detect Changes component. Both (columns component_bk) are equal configured (varchar 25 RAW) I always get "ERROR: could...

Table Output - data mismatch while truncate and insert records into target table

Output generated from Table Output sql query (sample) to the data getting loaded into target Redshift table is not matching. Component A (input): Column1;Column2 -------;------- 1;2 2;3 3;4 4;5 Table...

Filter to items in list

Is it possible to filter a list down to a subset, based on a list of id's in another list? As in a query such as: SELECT id FROM table1...

Map Values Component w/ NULL Default

Using the Map Values component, is it possible to achieve any of the below outcomes using explicit mappings (Value Map) or default values (Other)? - If no explicit mapping is...