AnsweredAssumed Answered

SQL Query EDC

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

Outcomes