topic Re: Split data in row level in App Development

Split data in row level

manojin123 — Thu, 12 Aug 2021 10:33:50 GMT

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.

Re: Split data in row level

Taoufiq_Zarra — Thu, 12 Aug 2021 10:42:20 GMT

@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:

Re: Split data in row level

manojin123 — Thu, 12 Aug 2021 10:57:35 GMT

Thank you Taoufiq_Zarra