Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Replacement for SQLike in tMAP

Hi All,
I am using TOS and we do not have SQLike Category/function in TOS. But I want to run a job which was built in Commercial version which had SQLike function. So now I am looking for a replacement for SQLike Function. Would you please suggest me what can be used for that?
The full String is as below:
(StringHandling.TRIM(StringHandling.LEFT(SQLike.mid(SAMPLData.DATA,11),4)))
Please suggest or let me know in case of any questions.
Thanks for the help...
Labels (2)
1 Reply
Anonymous
Not applicable
Author

Fell free to build your own routine. The whole magic is in a static Java method.
It would suggest open it in the enterprise version, take a look into the built-in routine there to get an idea how to build your own in your TOS environment.