topic Removing spaces from column names in Qlik Replicate

Removing spaces from column names

hale_52372 — Tue, 15 Nov 2022 12:13:59 GMT

Good Afternoon,

I am working on a database that has a large number of column names, with spaces in them.

I would like to set up a Global Rule to remove or replace all the spaces in column names I was wondering if we could use the replaceChars command in the Expression builder.

However I can not find any examples of the syntax of how to do this. Has anyone been able to successfully do this?

Thank you

Richard

Re: Removing spaces from column names

Pedro_Lopez — Tue, 15 Nov 2022 12:58:40 GMT

Hi Richard,

Thanks for reaching out.

You can use the replace() function under the Global Rules --> Expression Builder --> Functions --> Strings --> Replace(X,Y,Z)

Trying something quick here I could replace the spaces with empty characters by using this expression:

replace($AR_M_SOURCE_COLUMN_NAME,' ','')

You can also find more info here:

https://help.qlik.com/en-US/replicate/May2022/Content/Global_Common/Content/SharedEMReplicate/Customize%20Tasks/tasks_globTransRuleRenameCol.htm

Hope this helps, let us know if this is what you're to achieve.

Regards,

Pedro

Re: Removing spaces from column names

hale_52372 — Wed, 16 Nov 2022 15:42:20 GMT

Hello Pedro,

Thank you for the help, that worked first time .

Thanks

Richard