Skip to main content
Solved

keep only distinct values


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

View original
Did this help you find an answer to your question?

4 replies

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

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


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

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


david_r
Celebrity
  • 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
  • April 6, 2020
david_r wrote:

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.


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings