Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Converting CSV data held in table cell into seperate rows

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?

 

GroupApprover
L1User1; User2; User3
L2User2; User4; User5
L3User1; User5
L4User6
L5User7

 

GroupApprover
L1User1
L1User2
L1User3
L2User2
L2User4
L2User5
L3User1
L3User5
L4User6
L5User7

Thanks for your help.

1 Solution

Accepted Solutions
Anil_Babu_Samineni

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);

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)

View solution in original post

2 Replies
Anil_Babu_Samineni

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);

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)

View solution in original post

Not applicable
Author

That worked

Thanks Anil