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' ?
Page 1 / 1
The DuplicateRemover transformer can be used on multiple attributes. The Unique output port will generate what you need.
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'
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.
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:
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.