Discussion Board for collaboration on QlikView Scripting.
I have a requirement here where i need to convert multiple row values into single columns with some special characters
1 AB // CDEF// GHI // JKLMN
2 XYZ// UVWX // PR
if we use Concat function it will concatenate all the field values . But my requirement is i need '//' also between each field value.
do we have any other solutions to resolve this issue.
Go to Solution.
Use delimeter '//' with concat(), like:
Concat( Distinct Status, '//')
May be combination of Group by and Concat() like this?
Group by ID;
load *, rowno() as rn inline [
] (delimiter is spaces) ;
Concat(Status, ' // ', rn) as Status
DROP Table Source;