Hi Jonas,

In your Replication Cockpit when selecting a table you have the option of Transformation Configuration. These Transformations will be triggered by the corresponding extractions. If you want to update your view, a pracitcal approach (perhaps not the most efficient one) would be to simply create a table from the view, update the table, save it back to a view and replace the views with eachother.

This could be an example of the transformation you are looking for:

-- Transform the view into a table

CREATE TABLE SampleTable AS

SELECT *

FROM SampleView;

-- Alter the table to trim leading zeros

ALTER TABLE SampleTable

ADD COLUMN TrimmedValue VARCHAR(255); -- Assuming VARCHAR(255) as the data type

UPDATE SampleTable

SET TrimmedValue = LTRIM(Value, '0');

-- Drop the original view

DROP VIEW IF EXISTS SampleView;

-- Create a new view with the transformed data

CREATE VIEW SampleView AS

SELECT TrimmedValue AS Value

FROM SampleTable;

-- Drop the temporary table

DROP TABLE IF EXISTS SampleTable;

I hope this helps.

Best regards,

Tim