Discussion Board for collaboration related to QlikView App Development.
The requirement is quite simple, but some how its not working. Could you please help a bit?
I have a Field called COLUMN with values (ABC1, DEF1, 12345678, 87654321)
I need the output with 6 chars like COLUMN(123456,876543)
Also, I have right spaces besides ABC1 and DEF1. Need to remove the spaces as well.
or if you have just one row (ABC1, DEF1, 12345678, 87654321)
LOAD concat(left(trim(Field10), 6), ',') as Field10New WHERE isnum(subfield(Field10, ','));
LOAD subfield(purgechar(Field10, '()'), ',') as Field10;
LOAD * INLINE [
"(ABC1, DEF1, 12345678, 87654321)"