Calculation Problem?

[adyf]

I have 22 repeating fields with 5 repeats each giving a total of 110 fields. Some fields are blank and some fields are populated with duplicate information. I would like only the data that is unique replicating in another field. Thought I had written a killer calculation that compared each field in turn but I reached a maximum of 30000 characters in my calculation field and that was that. Is there an easier way? Unfortunately I am only using FM6 :frown:

Edited December 8, 2009 by Guest

[comment]

Perhaps you could define a value list, then use ValueListItems() to get a clean list without duplicates.

However... I am not sure what the purpose of all this is, and I have a feeling there's a simpler way to deal with the overall issue.

[bruceR]

Even though you are only using FM6 you can still switch to a proper relational design and kill all the repeats.