Skip to main content

Suggest an Idea

Vote for your favorite Qlik product ideas and add your own suggestions.

Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW

Replicate Multiple Global Transformation on same Objects

SandilyaDongar
Contributor III
Contributor III

Replicate Multiple Global Transformation on same Objects

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.

4 Comments
Meghann_MacDonald

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

Shelley_Brennan
Former Employee
Former Employee

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

Status changed to: Open - On Roadmap
Shelley_Brennan
Former Employee
Former Employee

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

Status changed to: Delivered
SandilyaDongar
Contributor III
Contributor III

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