
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
CLOB datatype
While performing any kind of transformation with CLOB datatype getting null in target.
Please guide on this.
Thanks,
GuptaN
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
Thanks
Lyka

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
For example :- abcd is a string and i need to replace d to z
while i am doing this getting null iin target

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
Thanks
Lyka

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
