Split data in row level

[manojin123]

Hi All,

Hope all is well,

Need help from you guys. I need to split cell values at row level with based on comma separate. is any know that how can i do in qlik sense. for better understand please see the below attached image. I am also attaching  sample data with expected result.

source Data is like this 

I need data as per below format.

[Taoufiq_Zarra · Accepted solution]

@manojin123  you can use Subfield, like :

Input:
load EmpID,subfield(Pod,',') as Pod;
LOAD * INLINE [
    EmpID, Pod
    12345, "VB_EB_Pet(3),VB_FrontDesk(3),VB_PLService(3),VB_PLService_Ancillary(3),VB_PLService_Billing(3),VB_PL_Care(3)"
    23456, "MRA_VOICEMAIL_AlexanderBaldwin(1),MRA_VOICEMAIL_DieboldNixdorf(1),VB_PLService(1),VB_PLService_Ancillary(1),VB_PLService_Billing(1),VB_PL_Care(1)"
];

output:

[manojin123]

Thank you Taoufiq_Zarra