Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Benkku
Partner - Contributor III
Partner - Contributor III

Ordering table columns in Qlik Replicate

Hi!

When copying  a table in Qlik Replicate, is there a way to decide in which order the columns shall appear in the target database?

For example, I have added the column full_name and I would like to locate it just after the column last_name.

community_forum_1.png

Thanks,

Bernardo Di Chiara

Labels (1)
  • Other

1 Solution

Accepted Solutions
john_wang
Support
Support

Hello @Benkku ,

If the target database is relational database eg Oracle, SQL Server etc, the order of the columns is meaningless because the DB itself will use optimized way to store the columns, eg fix length columns first then various length columns, simple structured type columns prior to unstructured type eg LOB columns etc. And all the apps who access the RDBs do not care about the columns order too.

If your target is non-RDB eg file type endpoints then we may control it. See my comment in article:

https://community.qlik.com/t5/Qlik-Replicate/File-Target-Endpoint-explicit-control-of-column-sequenc...

 

Hope this helps.

Regards,

John.

Help users find answers! Do not forget to mark a solution that worked for you! If already marked, give it a thumbs up!

View solution in original post

7 Replies
john_wang
Support
Support

Hello @Benkku ,

If the target database is relational database eg Oracle, SQL Server etc, the order of the columns is meaningless because the DB itself will use optimized way to store the columns, eg fix length columns first then various length columns, simple structured type columns prior to unstructured type eg LOB columns etc. And all the apps who access the RDBs do not care about the columns order too.

If your target is non-RDB eg file type endpoints then we may control it. See my comment in article:

https://community.qlik.com/t5/Qlik-Replicate/File-Target-Endpoint-explicit-control-of-column-sequenc...

 

Hope this helps.

Regards,

John.

Help users find answers! Do not forget to mark a solution that worked for you! If already marked, give it a thumbs up!
Benkku
Partner - Contributor III
Partner - Contributor III
Author

Hi John!

Thanks for your answer!

Good hint! However, once you have to remove all the columns from the output list in the Transform window, I guess you can simply insert them back in the wished order even by using the original column name in the name field.

Still, this method might be not practical when you have  a huge amount of columns.

Best Regards,

Bernardo

john_wang
Support
Support

Hello @Benkku ,

You are right, it's a time consumed job to adjust the columns order in GUI but I think it's the best way. 

Regards,

John.

Help users find answers! Do not forget to mark a solution that worked for you! If already marked, give it a thumbs up!
NakulanR
Partner - Contributor III
Partner - Contributor III

Hi,

Just wondering if there have been any changes to Replicate to allow for an easier column ordering method. As @Benkku mentioned, the method provided in this community article may work but is also tedious when you have several columns and tables.

If there aren't any ways of ordering the columns easily in the newer releases of Replicate, is it something that is planned for future releases? At the moment I can't see any posts about it in Ideation so I'm not sure if the idea has already been declined.

Any insight is greatly appreciated.

 

Regards,

Nak

SushilKumar
Support
Support

Hello Team,

 

you can actively engage with our Product Management team, vote on a product idea coming for other Qlik customers, submit your own ideas and get feedback from other members.

 

To get started please see our article: "Getting Started with Ideas":  https://community.qlik.com/t5/Qlik-Product-Insight-Blog/Getting-Started-with-Ideas/ba-p/1684011

 

Regards,

Sushil Kumar

Heinvandenheuvel
Specialist II
Specialist II

You could also pre-create the table(s) on target amd tell Replicate not to dropn& create on fullload but truncate instead.

NakulanR
Partner - Contributor III
Partner - Contributor III

Thanks @SushilKumar, I'll look into submitting an idea in the ideation page. 

Unfortunately ADLS is being used as the target in this use case so creating the tables on the target probably won't work. But good to know that it could work with a database type endpoint which has tables. Thanks for the suggestion @Heinvandenheuvel