Skip to main content
  • EN

I'm trying to duplicate the Asteryx's Unique Tool (http://help.alteryx.com/9.5/index.htm#cshid=Unique... in FME. Using the DuplicateRemover doesn't give me the results that I want.

 

 

This is what I need. I have a field that needs to be unique (FiledB) and it's associated with another field (FieldA). A1A 2A3A4B1B3B4B5C5C6

What I should be getting for result is: A1, B5 and C6.

 

 

The result that I get with the RemoveDuplicate by selecting only the FieldB as the unique, or both fileds, doesn't give me this.

Any suggestions?

If you use the DuplicateRemover on Field B, followed by a second DuplicateRemover on Field A attached to the Unique port of the first DuplicateRemover you would get the required result.

If you use the DuplicateRemover on Field B, followed by a second DuplicateRemover on Field A attached to the Unique port of the first DuplicateRemover you would get the required result.

But wouldn't you lose records like that? ie the first pass would leave you A1, B1, C5 and the second pass would leave you just A1, C5 (B is lost)

Why B5, C6? Any reason you can't have B3, C5? Also, if the next record is D1, would that mean you couldn't have A1? That would make a difference, and some scenarios would be im

But wouldn't you lose records like that? ie the first pass would leave you A1, B1, C5 and the second pass would leave you just A1, C5 (B is lost)

After the first DuplicateRemover you have A1, A2, A3, A4, B5, C6 After the second A1, B5 and C6.

After the first DuplicateRemover you have A1, A2, A3, A4, B5, C6 After the second A1, B5 and C6.

Got it. I was looking at the other field first!

Reply


Community Stats

30,112
Posts
114,303
Replies
37,745
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.