topic Converting CSV data held in table cell into seperate rows in QlikView

Converting CSV data held in table cell into seperate rows

Wed, 25 Nov 2020 16:16:04 GMT

I've imported a SharePoint List into a QlikView report but some of the data has been returned as CSV (semi-colon separated) in table cells, shown in the first table.

I would like to split this in to separate rows, shown in the second table.

Can this be done?

Group	Approver
L1	User1; User2; User3
L2	User2; User4; User5
L3	User1; User5
L4	User6
L5	User7

Group	Approver
L1	User1
L1	User2
L1	User3
L2	User2
L2	User4
L2	User5
L3	User1
L3	User5
L4	User6
L5	User7

Thanks for your help.

Re: Converting CSV data held in table cell into seperate rows

Anil_Babu_Samineni — Fri, 05 May 2017 16:52:20 GMT

Do this?

Load Group, SubField(Approver,';') as Approver;

LOAD Group,

Approver

FROM

[https://community.qlik.com/message/1262900]

(html, codepage is 1252, embedded labels, table is @1);

Re: Converting CSV data held in table cell into seperate rows

Fri, 26 May 2017 08:41:04 GMT

That worked

Thanks Anil