substring in Load Script

[theboss-123]

hello im looking for an alternatif solution for the syntaxe on SQL substring('ITM_REF',1,2) in ('15') is this possible on load script as a condition ?

[vinieme12 · Accepted solution]

You can use Mid(), refer below link

https://help.qlik.com/en-US/sense/May2022/Subsystems/Hub/Content/Sense_Hub/Scripting/StringFunctions...