A negation for "RepetitionNotUnique/FieldValuesNotUnique"

huyen-gentle-brush · April 10, 2025, 7:41am

Hi,
I’m looking for a opposite rule of the “RepetitionNotUnique/FieldValuesNotUnique” to complete my computation in both case “unique” and “notUnique”. Are there any possibility?

malcolm-silver-ice · April 10, 2025, 7:59am

Hi @huyen-gentle-brush

Depending on whether you are looking at the whole repeat or each line you can model a Rule. I’ve attached a 2023.06-ext6 model to show you.
IsUnique_DM.json (5.1 KB)

All Values of StringField are unique:

MoreThanOneFieldFilled(MyRepeat*/StringField)
And NumberOfDifferentValues(MyRepeat*/StringField) == NumberOfFilledFields(
        MyRepeat*/StringField)

This value of String Field is unique:

FieldFilled(StringField)
And NumberOfFilledFields(../MyRepeat*/StringField Having [StringField] == [$StringField]
        ) == 1