Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

alkesh_sharma
Contributor II

Splitting Multiple entries into different columns

Hello Experts,

I have a data in below format:

Invoice No.Scheme Code
121A01
121A02

I need the same data in below format:

Invoice No.Scheme Code1Scheme Code2
121A01A02

Thanks in advance

1 Solution

Accepted Solutions
senpradip007
Valued Contributor III

Re: Splitting Multiple entries into different columns

Have a look on the attachment. Hope it will solve your problem.

3 Replies
senpradip007
Valued Contributor III

Re: Splitting Multiple entries into different columns

Have a look on the attachment. Hope it will solve your problem.

alkesh_sharma
Contributor II

Re: Splitting Multiple entries into different columns

Thanks Sir, this will do the trick...Smiley Happy

senpradip007
Valued Contributor III

Re: Splitting Multiple entries into different columns

welcome!!!!

Community Browser