I'm attempting to remove duplicate values, but only if they are within a subset of my data:
Is there a way to remove the duplicate 'Lease Number' within each unique 'Unit Name' ?
Solved
Remove duplicates within a subset of data
+1- Contributor
Best answer by gio
you can also create a list grouped by both columnnames, and then use a listindexer or histogrammer etc..
Or use a Matcher non geometric, then you can use bot attributes to find the uniques.
+18- Contributor
The DuplicateRemover transformer can be used on multiple attributes. The Unique output port will generate what you need.
+1- Contributor
erik_jan wrote:
The DuplicateRemover transformer can be used on multiple attributes. The Unique output port will generate what you need.
Hi erik_jan,
I've tried the transformer you suggested, in different combinations am I missing something? The only output in all these combinations is '1 Alpha'
+15- Contributor
- Best Answer
you can also create a list grouped by both columnnames, and then use a listindexer or histogrammer etc..
Or use a Matcher non geometric, then you can use bot attributes to find the uniques.
+18- Contributor
ngstoke wrote:
Hi erik_jan,
I've tried the transformer you suggested, in different combinations am I missing something? The only output in all these combinations is '1 Alpha'
You want one DuplicateRemover with both attributes selected:
+1- Contributor
gio wrote:
you can also create a list grouped by both columnnames, and then use a listindexer or histogrammer etc..
Or use a Matcher non geometric, then you can use bot attributes to find the uniques.
That worked! Thanks for the help.
Reply
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.