In a table, I had 4 fields, Knowledge Base, Domain, Groups and Users.

[Raghu Ram Y]

I have a table with four fields: Knowledge Base, Domain, Groups, and Users. The Groups and Users fields are list collectors. I need to create a database view or report that displays each user and each group as a separate record.

Example :

At Present

Knowledge Base	Domain	Groups	Users
KBA	global	GroupA,GroupB,GroupC	UserA, UserB, User C

My Expectation in Report/DatabaseView  - Separate reports for Groups and Users

Group Report

Knowledge Base	Domain	Groups
KBA	global	GroupA
KBA	global	GroupB
KBA	global	GroupC

User Report

Knowledge Base	Domain	Users
KBA	global	UserA
KBA	global	UserB
KBA	global	UserC

@Ankur Bawiskar @Dr Atul G- LNG 

[Raghu Ram Y]

@Ankur Bawiskar function field is something helps to update the field value, but here I want to split and create the records in next rows too, so I'm not sure in such case if it's helpful.

[Dr Atul G- LNG]

Hi @Raghu Ram Y 

Good to see you, mate, and congrats on being an MVP! Since these fields are in the same table, the database view will not work. I tried creating a pivot table, but it’s only showing the sum, not the value, even though I added the function field as well. I tried using the substring to get the name of the group, but it didn’t work. I also tried the field name in the function, but it still didn’t work. I recommend logging a case with Now Support and asking how to get the field value in the function field.