Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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);
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);
That worked
Thanks Anil