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




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

for ex- userid,accessdata




           "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.