Skip to main content
Solved

Unique Value generator

  • March 1, 2016
  • 5 replies
  • 32 views
D

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?

Best answer by erik_jan

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.

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

5 replies

erik_jan
Contributor
Forum|alt.badge.img+23
  • erik_janContributor
  • Contributor
  • Best Answer
  • March 1, 2016

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.

mark2atsafe
Safer
Forum|alt.badge.img+59

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)

FME Evangelist to the Rich and Famous!!
mark2atsafe
Safer
Forum|alt.badge.img+59

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

FME Evangelist to the Rich and Famous!!
erik_jan
Contributor
Forum|alt.badge.img+23
  • erik_janContributor
  • Contributor
  • March 1, 2016

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.

mark2atsafe
Safer
Forum|alt.badge.img+59

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!

FME Evangelist to the Rich and Famous!!

Community Stats

32,154
Posts
122,046
Replies
39,812
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
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.