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