Convert Comma Separated column value to rows

[Anonymous]

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]

Try using subfield function here:

LOAD Id,

          SubField(String, ',') as processedrows

FROM Source;

[Anil_Babu_Samineni]

Try

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

[sunny_talwar]

Check out the sample

Table:

LOAD Id,

  SubField(String, ',') as processedrows;

LOAD * INLINE [

    Id, String

    1, "abc,def,ghi"

    2, "jkl,mno,pqr"

];