Remove duplicates from repeating group

Good day. I am hoping for a pointer on how to eliminate from view duplicate entries in my repeating group.

Effectively I am organizing several things under common categories. I want to display those categories to allow users to bulk hide / remove the category and accompanying Topics from their workflow. (I can likely handle the hide function, I am just stuck on displaying each unique category only once)


Hi there, @K.T… if I understand your post correctly, it sounds like you could go with a repeating group inside of a repeating group. So, the main repeating group would have a data source that shows the categories, and the second repeating group (which would be inside the main group) would show the topics that are associated with the current cell’s category. Is that what you are trying to do? If so, how have you defined the categories? Maybe with an option set?


@mikeloc Thank you for the input!

I am only interested in displaying the categories, which I can do, but I get the far example on the right where Category A is displayed 3 times b/c it is associated to 3 topics in my table. I am trying to achieve the desired outcome on the left where only 3 cells are displayed.

I am calling the DB directly, no option sets.

I’ve mucked about with group by, but so far that has just lumped every category together and repeated across numerous cells.

Have you tried an expression like Search for topics:each item's category:unique elements?


Appreciate the time and suggestions - I am getting an error with the above expression that it evaluates to a list, which I don’t think I want b/c I want to give end-users the ability to then hide/show each category individually.

Time for a quick walk to clear my head :slight_smile:

Hmm, I must be missing something because if you are going to show categories in a repeating group, then you would want it to evaluate to a list.

@mikeloc truly appreciate the advice. I’m sure it is just my mistake in figuring out why I either just get add’l errors or different permutations of grouped data (but still multiples of the same value in these alternative groups).

I’ll keep plugging away and likely do a forehead bump when I find it was something simple.


1 Like

This topic was automatically closed after 70 days. New replies are no longer allowed.