Subfield doing a distinct automatically

[diwaskarki]

Hello Guys,

I think when I use subfield on a string, it automatically does a distinct.

For example in my database i have a user Tim. So lets say Tim is the key and the value for tim is stored in a field called 'Role'.

Data stored in 'Role' for the key 'Tim' looks like this:

   Key                    Role                                                                      Date

   Tim                B2E Role, B2C role, B2D Role,         102124541

    Tim               B2E Role, Selfmade Role, Tims Role                  5432112132 

     Tim                Selfmade Role, Tims Role, handy role               4512145421

I am doing a subfield on role like this : Subfield(Role, ',') As [Separated Role]. So now role stores data like this

  B2E Role

  B2C Role

   B2D Role

Selfmade Role

Tims Role

handy role.

I have a listbox that display Tim and another table that display Role. When I click on Tim , I want to see:     

B2E Role

B2C Role

B2D Role

B2E Role

Selfmade Role

Tims Role

Selfmade Role

Tims Role

handy role

But i do not see the duplicate values. Is there a workaround to this?

[rwunderlich · Accepted solution]

A table will display one row for each unique combination of dimension values. If you are only displaying [Separated Role], you would only see each value once.  You will need to include another dimension such as Date.

-Rob

[diwaskarki]

Thank you so much Rob