Separate String and combine into one field

crystles — Tue, 17 Jan 2017 15:05:23 GMT

I have a field that we are pulling from Active Directory that they are using to store user roles for a separate program.

I need to use these fields in a document, but the problem is, if the user has more than one role, it just adds them to the field with a space and comma separating them. See example

AD UserName	RoleID
John	Admin
Sally	Admin, Update
Bob	Update

Looking at the example, the user "John" and "Bob" would not be a problem. However, Sally has two roles, and they are both listed in the same field.

What I need my report to look like, in order to feed it into the Qlikview document we have, is for it to look like the example below instead. Any help or advice would be greatly appreciated.

AD UserName	RoleID
John	Admin
Sally	Admin
Sally	Update
Bob	Update

Re: Separate String and combine into one field

sunny_talwar — Tue, 17 Jan 2017 15:09:39 GMT

Try like this:

LOAD [AD UserName],

Subfield(RoleID, ', ') as RoleID

FROM ....

Re: Separate String and combine into one field

crystles — Tue, 17 Jan 2017 15:21:01 GMT

That worked perfectly! Thank you!

topic Separate String and combine into one field in QlikView

Separate String and combine into one field

Re: Separate String and combine into one field

Re: Separate String and combine into one field