Merge multiple rows into one

[satyender]

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

[satyender]

Hi @SwathiPulagam ,

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

[satyender]

Thanks @john_wang  for your response.

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

[SwathiPulagam]

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]

Hi @SwathiPulagam , @john_wang 

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

[Heinvandenheuvel · Accepted solution]

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]

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]

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.