topic Re: Expression Builder unrecognized token in Qlik Replicate

Expression Builder unrecognized token

kyle_ch — Thu, 08 Jul 2021 19:50:26 GMT

Trying to get data from a legacy database that uses some special characters in a few of the column names. When trying to use the Expression Builder I get the following error "SQLite general error. Code <1>, Message <unrecognized token: "#">.

This occurs even when trying to select it directly in the Columns section of the Expression Builder. example: ACCT#

Thanks in advance for any help.

Re: Expression Builder unrecognized token

jjames — Thu, 08 Jul 2021 23:38:45 GMT

Hi @kyle_ch

It seems like a limitation that is mentioned on the below page.

"Transformations cannot be performed on columns that contain special characters (e.g. #, \, /, -) in their name."

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

If you are only looking for Full Load operation and not CDC, then you may create a view of the same table avoiding the special characters in the column and then use that view in the Replication Task.

Thanks,

jjames

Re: Expression Builder unrecognized token

kyle_ch — Fri, 09 Jul 2021 12:47:18 GMT

That talks about Global Transformations and to say "Transformations cannot be performed on columns that contain special characters in their name" is a bit of a mislead as I am able to do basic transformations and rename the column (mostly to take out the special character), I am just unable to do anything in the Expression Builder.

Unfortunately, we are looking for a full load followed by CDC.

Re: Expression Builder unrecognized token

Tianna — Wed, 14 Jul 2021 05:59:17 GMT

@kyle_ch wrote:
Trying to get data from a legacy database that uses some special characters in a few of the column names. When trying to use the Expression Builder I get the following error "SQLite general error. Code <1>, Message <unrecognized token: "#">.
This occurs even when trying to select it directly in the MyBalanceNow Columns section of the Expression Builder. example: ACCT#
Thanks in advance for any help.

This function splits up the <character_expression> string into a set of tokens separated by the delimiters specified in the <delimiter_string> and then returns the Nth token where N is the number of occurrence of the token specified by the <occurrence> parameter. See Examples section for sample usages of this function.