Transformation Components

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...

Date dimension table creation job

Does anyone have a create date dimension table job they can share? I've seen reference to one in the online documentation. I'd rather not re-invent the wheel here if there...

Overview of Transformation Components

Hi Team, Just want to check if we have any document/reference to go through to understand different Transformation Componenets available in Matilion. Regards, Sunil Gupta

How about a "Read View" component in a transformation.

I see that you can now create a view in a transformation; but, how about reading a view? For our situation, it would be beneficial for us to define a...

Insert/Update does not appear to work

This is roughly what I am testing: - I have a table with these columns: - ID1 - ID2 - VALUE1 - VALUE2 I have 2 S3 files with the...

Associate Sequence to a data flow

I am having trouble adding the sequence transformation to an existing flow. I want to generate a key using the sequence generator transform but I am struggling to add that...