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.
Thanks,
Bernardo Di Chiara
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:
Hope this helps.
Regards,
John.
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:
Hope this helps.
Regards,
John.
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
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.
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
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
You could also pre-create the table(s) on target amd tell Replicate not to dropn& create on fullload but truncate instead.
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