Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
Have one ID column (data type is string in Qlik) and want to extract 2nd and 3rd character from it as belows:
I have tried using Subfield but not working as required. Please help.
Many Thanks,
LOAD Num(Mid(ID,2,2)) as ExpectedOutput
FROM ...