topic Re: CLOB datatype in Qlik Replicate

CLOB datatype

GuptaN — Thu, 17 Mar 2022 14:35:23 GMT

While performing any kind of transformation with CLOB datatype getting null in target.

Please guide on this.

Thanks,

GuptaN

Re: CLOB datatype

john_wang — Thu, 17 Mar 2022 14:46:31 GMT

Hello @GuptaN ,

In general, yes, you cannot do any transformation for LOB columns, see User Guide Limitations :

The only supported transformation for LOB/CLOB data types is to drop the column
on the target.

However I'd like to understand what's the exact needs about the transformation and it's better a sample to see if any work around.

Regards,

John.

Re: CLOB datatype

GuptaN — Thu, 17 Mar 2022 15:45:45 GMT

For example :- abcd is a string and i need to replace d to z
while i am doing this getting null iin target

Re: CLOB datatype

lyka — Thu, 17 Mar 2022 16:10:34 GMT

Hello,

There is a replace function that you can use for string datatypes.

Replace() returns a string after replacing all occurrences of a given substring within the input string with another substring. The function is non-recursive and works from left to right.

Syntax:

Replace(text, from_str, to_str)

Return data type: string

however i dont think this is applicable for lob columns. As what John said,

The only supported transformation for LOB/CLOB data types is to drop the column
on the target.

https://help.qlik.com/en-US/qlikview/May2021/Subsystems/Client/Content/QV_QlikView/Scripting/StringFunctions/Replace.htm

Thanks

Lyka

Re: CLOB datatype

Heinvandenheuvel — Thu, 17 Mar 2022 20:15:47 GMT

This question is often about just about replacing some (exception) characters like new-line, carriage-return or accented characters. If that's the case, then checkout the replaceChars internal parameter. Search this forum (classic search) for it. Or jump to : https://community.qlik.com/t5/Qlik-Replicate/remove-LF-line-feeder/m-p/1898082

Also note the LOB/CLOB manipulation is NOT available through UDT functions either (User Defined Transformation)

Hein.