Is there an equivalent to the "de-duplicate" function in Surveycto?

[jscorrea]

Dear all,
I have a repeat group built for multiple plots and I ask about the crops planted and harvested in each plot.
After that I use the “join” function and I get all the names for the crops in order to ask subsequent questions for each crop, but since a same crop can be grown in multiple plots, I might get the same crop more than once. Is there a way to eliminate those entries that are repeated, such that I only get to keep one? There is a function in surveycto called “de-duplicate” but it appears not to be supported in Kobo.
Thank you

[Kal_Lam]

@jscorrea, this post discussed previously should help you solve your issue:

Restrict choices already selected from a repeat group

Hi @an_ju, Have you considered using a choice filter rather than constraints? Here’s something that might work for your situation: survey type name label calculation choice_filter calculate c1 concat(${visit}) begin_repeat visits Visits calculate c2 substr(${c1}, 0, position(…) - 1) select_one visits visit Visit not(contains(${c2}, name)) end_repeat choices list_name name label visits 0 Visit 3A visits 1 Visit 3B visits 2 Visit 3C choice-filter-re…

[jscorrea]

Thank you. This does not solve the issue since I do not want to restrict the crop choices for each plot. It is ok for example that maize is planted in more than one plot.
As explained, I want to ask, in a different section, questions for all the crops in the repeat group. The function “join” allows to extract all crop choices, but will have repeated choices if the same crop is planted in more than one plot.

[Kal_Lam]

@jscorrea, maybe you could share your XLSform with the community. The community should be able to help you out.