Discussion Board for collaboration on QlikView Scripting.
i want to replace zero with '' in the IDs, but just zero at the beginning of the ID in load script
000574 ---> 574
Go to Solution.
load id+0 as new;
load * inline [
Why second row only should change? Because, Of only one 0 is there?
May be this
Replace(LTrim(Replace(String, '0', ' ')), ' ', '0') as String
i want delete just the zero at the beginning
Multiply with 1 to field