AnsweredAssumed Answered


Question asked by Jason Shepard on Dec 14, 2017
Latest reply on Dec 14, 2017 by Boris Lekumovich

Hi All,


I am working on onboarding a new application. For the most part The entitlement collector is working, however, I believe it could be doing a better job.  I am pulling data from an .csv file. The data consists of user and role. The issue I am seeing is that the roles are all aggregated together on a single row separated by a ;.  When collecting the data, it take the who cell value and creates the app role like this



Here is a screenshot of the data



Is there a way to query it so the app roles are broken out individually similar to this.   Changing the report is not an option from the source.



Here is my basic query:



Thank You