This content has been marked as final. Show 2 replies
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
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.