I am using Qlik Sense 1st time. I am trying to add text before number, which is not working.
I did tried Dual & right (Field -1) or
Text & right (Field -1). But I am getting out put as "-".
I want output as Field2
you can use string functions.
Left(field1,1)&''&(Mid(field1,2)-1) as field2
Something like (this will preserve the first character
Left(field1, 1) & (Num(KeepChar(field1, '0123456789')) - 1)
Left(field1, 1) & (Num(Mid(field1, 2, len(field1))) - 1)
Try this also
left(field1,1)&Text(right(field1,4)-1) as Newfield1;
LOAD * INLINE [
This work perfectly, Thanks
Retrieving data ...