Discussion Board for collaboration on QlikView Scripting.
load inline [
How to remove names,alphabets and leading zeros
Go to Solution.
LOAD Num(KeepChar(Department, '0123456789'), '00') as Department;
load * inline [
Floor(KeepChar(Department,'0123456789')) as Department
Thanks for reply Sunny. It's working fine.