Hello all, I have a need to build a rule that checks for uniqueness for a particular column and have tried a couple of methods using Record Descriptor Builder and (now) Group Aggregator. The Record Descriptor Builder rule (Testing for uniqueness for a field) works “except” it shows multiple rows for a given invalid result so that not ideal for the dashboard. **I attempted to use the “Filter” to remove the duplicates but Ataccama didn’t like inconsistent input vs output results.
Which leads me to trying Group Aggregator. My goal was to group my column and flag a record as “invalid” where the count is greater than 1 (not unique). My issue is that it doesn’t allow the required “result” shadow column (from the input) to flow down through Group Aggregator to the output. I’ve tried to use “Alter Format” to add the “result” column but receive errors when running the rule.
Here’s what my rule looks like:
Rule output:
Has anyone else used a similar rule building method or created a different rule to check for uniqueness?
Thanks in advance,
Mike Roberts