idea Re: Replicate Multiple Global Transformation on same Objects - Status changed to: Open - On Roadmap in Suggest an Idea

Replicate Multiple Global Transformation on same Objects

SandilyaDongar — Fri, 13 Nov 2020 21:41:51 GMT

Hello,

Source: SQL Server, Target: Snowflake on Azure

While using Global Transformations (GT) within Replicate, we've observed that multiple-global transformations are not getting applied on the same objects. So basically, Replicate is applying only the first created GT and not applying the GT's which are created later if they refer to same column/table.

As a part of our requirement, we need to convert all of our columns to UpperCase and also convert few of the column datatypes on the fly from Replicate to Snowflake. Since multiple-GTs are not being applied on the same column nor there is a cast function to combine them in a single case statement GT, only the first created GT is getting applied in our target but we need both uppercase & datatype conversions on the same column to be applied.

I've already discussed this with Qlik support reps and they suggested to request here if it is possible to add this feature for enabling multiple-global transformations on the same objects within Replicate in future upgrades?

Thank you,

Sandilya Dongar.

Re: Replicate Multiple Global Transformation on same Objects

Meghann_MacDonald — Fri, 13 Nov 2020 21:42:29 GMT

Hi @SandilyaDongar , in the future please only apply 1 tag per idea. Refer to the Ideation Guidelines posts with any further questions.

Re: Replicate Multiple Global Transformation on same Objects - Status changed to: Open - On Roadmap

Shelley_Brennan — Wed, 23 Dec 2020 14:14:51 GMT

Thank you for the feedback. This is being considered for a future release and we will update as to when it will be available.

Re: Replicate Multiple Global Transformation on same Objects - Status changed to: Delivered

Shelley_Brennan — Thu, 13 May 2021 14:35:07 GMT

With our May 2021 release, Replicate does now support applying multiple transformations to the same object. Thank you!

Re: Replicate Multiple Global Transformation on same Objects

SandilyaDongar — Thu, 13 May 2021 14:48:51 GMT

Thanks a lot. Was able to test it out and worked perfectly as required!