Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
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
Thank you so much Rob