Skip to main content
Solved

keep only distinct values

  • April 6, 2020
  • 4 replies
  • 1417 views

Forum|alt.badge.img

Hello

After an "attributeKeeper" transformer I try to obtain a selection with distinct value for each row like a "select distinct" sql command. But I fail to find a good solution.

(I didn't find the DuplicateRemove transformer)

Do you know to do it ?

Thanks

 

 

 

Best answer by ebygomm

You want a duplicatefilter, distinct values will exit via the unique port

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.

4 replies

ebygomm
Influencer
Forum|alt.badge.img+44
  • Influencer
  • 3427 replies
  • Best Answer
  • April 6, 2020

You want a duplicatefilter, distinct values will exit via the unique port


Forum|alt.badge.img
  • Author
  • 27 replies
  • April 6, 2020

Yes. it works... I had not seen this transformer.


david_r
Celebrity
  • 8392 replies
  • April 6, 2020

Sometimes transformers are renamed, but the old names are still usable as aliases. To take the example of the DuplicateRemover that was renamed to DuplicateFilter: If you simply type "duplicate" or even "duplicateremover" into the transformer quick add search box (start typing directly from the canvas), you will see the old transformer names in italics, pointing to the new name.

Example:

 


Forum|alt.badge.img
  • Author
  • 27 replies
  • April 6, 2020

Sometimes transformers are renamed, but the old names are still usable as aliases. To take the example of the DuplicateRemover that was renamed to DuplicateFilter: If you simply type "duplicate" or even "duplicateremover" into the transformer quick add search box (start typing directly from the canvas), you will see the old transformer names in italics, pointing to the new name.

Example:

 

thanks I did'nt know this tip.