topic Re: Ordering table columns in Qlik Replicate in Qlik Replicate

Ordering table columns in Qlik Replicate

Benkku — Fri, 15 Nov 2024 22:40:40 GMT

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

Re: Ordering table columns in Qlik Replicate

john_wang — Fri, 30 Jul 2021 07:56:25 GMT

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-sequence/m-p/1786409#M773

Hope this helps.

Regards,

John.

Re: Ordering table columns in Qlik Replicate

Benkku — Mon, 02 Aug 2021 13:37:07 GMT

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

Re: Ordering table columns in Qlik Replicate

john_wang — Thu, 05 Aug 2021 10:33:35 GMT

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.

Re: Ordering table columns in Qlik Replicate

NakulanR — Thu, 09 Nov 2023 02:46:38 GMT

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

Re: Ordering table columns in Qlik Replicate

SushilKumar — Thu, 09 Nov 2023 03:31:50 GMT

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

Re: Ordering table columns in Qlik Replicate

Heinvandenheuvel — Thu, 09 Nov 2023 03:34:50 GMT

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

Re: Ordering table columns in Qlik Replicate

NakulanR — Thu, 09 Nov 2023 04:43:45 GMT

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