Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Convert Comma Separated column value to rows

Hello,


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

Capture.PNG

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

3 Replies
sunny_talwar

Try using subfield function here:

LOAD Id,

          SubField(String, ',') as processedrows

FROM Source;

Anil_Babu_Samineni

Try


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

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
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"

];


Capture.PNG