Skip to main content
Announcements
UPGRADE ADVISORY for Qlik Replicate 2024.5: Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
satyender
Creator
Creator

Merge multiple rows into one

Hello Team,

I have a requirement of loading the tables from Source to Target. There are multiple rows in the target tables which I need to combine into one row for each table. 

Could you please suggest  how to do it in Qlik Replicate?

 

Thanks!

Satyender

Labels (1)
16 Replies
satyender
Creator
Creator
Author

Hi @SwathiPulagam ,

Yes, I want to combine the  multiple Comment rows into one. 

 

satyender
Creator
Creator
Author

Thanks @john_wang  for your response.

I want this to be done at Full load stage in Qlik Replicate data load task. 

 

SwathiPulagam
Support
Support

Hi @satyender,

 

As @john_wang suggested the easy way to do this is to create a VIEW in Source DB, the view must return one row based on your use case. You can set up a Full load task pointing to the view.

 

Thanks,

Swathi

satyender
Creator
Creator
Author

Hi @SwathiPulagam , @john_wang 

Unfortunately, we cannot do anything on the Source as we have only SELECT Permissions on the Source DB.

 

 

Heinvandenheuvel
Specialist III
Specialist III

Replicate can not do this.

A view on the source is probably the best solution as the data will be 'condenced'. Fewer rows, less redundant data.

>>  we cannot do anything on the Source as we have only SELECT Permissions on the Source

If the project is valid, important enough, then someone can create a view for you. It's a one-time thing.

The Source DB layout was apparently good enough for its patrons, but understandably not desirable for the target DB users.

A view of the target is probably the next best solution.

I'd also look into treating the target table as an intermediate - helper table and run a daily or hourly transform to the real target table for the latest rows. There is possibly (probably?) more thinks to do to make the data better useable on the target. You may find that change tables are the preferred way to solve this although with those any update to a comment column would be rather tricky.

 

Hein

 

satyender
Creator
Creator
Author

Thank you @Heinvandenheuvel  for your response.

I have created Views on the target already as this is an extra step after loading the data I was looking for a solution while loading the data using Qlik Replicate. I guess  I need to go with the Views on the target Snowflake and Clone them to the Database tables for now. 

Thank you all for your responses. 

Have a great weekend!

satyender
Creator
Creator
Author

Hello Everyone,

I have replied earlier but somehow not seeing my responses here. It's weird. 

Anyway, I am thinking to go with Views on Target. 

 

Thanks everyone for your responses.