Discussion Board for collaboration on QlikView Scripting.
Hi All, I need to create the new field based on existing field. I need to add 3 to each number in a field.
Field --> NewField
325 --> 333235
A3C --> 3A333C
4518 --> 34353138
I achieved this script. But the script took longer times to load
LOAD * INLINE [
LOAD ID , Concat(HID , '' , S) AS HID
Group BY ID;
LOAD ID , 3& Mid(ID , IterNo() ,1) AS HID , IterNo() AS S
Resident T While IterNo() <= Len(ID) ;
But this small piece of code took longer times.
So there any other way to achieve this with lower reload time.
Well, you could try a mapping table and mapsubstring