AnsweredAssumed Answered

CSV Entitlement Data Collection

Question asked by shakti nayak on Feb 14, 2018
Latest reply on Mar 5, 2018 by Pradeep Kadambar

We have an user-entitlement relationship csv file for an application.

This file  has two columns userid and accessdata where "accessdata" is a multivalued list of entitlements separated by comma.

Ex-      userid,accessdata

            "abc","ent1,ent2,ent3"

            "xyz","ent4,ent2"

 

We want to parse this data on collection to represent the below one to one user-entitlement relationship

for ex- userid,accessdata

            "abc","ent1"

           "abc","ent2"

           "abc","ent3"

           "xyz","ent4"  and so on.

But we are unable to do so. The same can be parsed easily if it is a oracle, mysql or ms sql db table/view.

But for csv the parsing fails everytime.

Any suggestions.

Outcomes