Solved

keep only distinct values

  • 6 April 2020
  • 4 replies
  • 229 views

Badge

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

 

 

 

icon

Best answer by ebygomm 6 April 2020, 14:17

View original

4 replies

Badge +10

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

Badge

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

Userlevel 4

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:

 

Badge

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.

Reply