topic Re: Convert Comma Separated column value to rows in QlikView

Convert Comma Separated column value to rows

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hello,

I have a table Sample with data stored like below in excel spreadsheet.

I need to process the data and store it in the QVD file for further calculations. Appreciate any inputs.

sunny_talwar — Mon, 26 Sep 2016 16:05:46 GMT

Try using subfield function here:

LOAD Id,

SubField(String, ',') as processedrows

FROM Source;

Anil_Babu_Samineni — Mon, 26 Sep 2016 16:08:55 GMT

Try

Subfield(processdrow,',',chr(10))

sunny_talwar — Mon, 26 Sep 2016 17:36:25 GMT

Check out the sample

Table:

LOAD Id,

SubField(String, ',') as processedrows;

LOAD * INLINE [

Id, String

1, "abc,def,ghi"

2, "jkl,mno,pqr"

];