[image] RowId are duplicate We need to fetch unique RowId based on Rank What is the correct approach that should be followed? For getting Rank column correctly.

Hi @shwetaoza , you should provide the data as a file (csv, Excel), or at least as Text that we can copy in our workflow. We can’t copy these numbers from a picture. One question though, should you not have a column for “Suzuki”? What you have in your latest picture is quite straight forward to implement: Step1: Add Given data to a Table: [image] Step2, you can use the Rule Engine node: [image] Note: I default to 0 any Car that is not any of (“Audi”, “Toyota”, “Suzuki”) Step3: you can use the Duplicate Row Filter on RowId and keep the lowest Rank value: [image] [image] Step4: you can use the Column Expression node: [image] Step5: you can use Column Filter [image] And after all this, this is the result: [image] Of course, you can adjust all this to add the column Suzuki if ever it was supposed to be there. Here’s what the workflow looks like: [image] And here’s the workflow: Rank based on column value.knwf (11.8 KB)

How to give Rank based on Column Value

KNIME Analytics Platform

mlauber71 May 27, 2021, 7:41pm 5

You could try and get some inspiration from the:

There also is an example with H2 standalone database and using window functions.

Filter Duplications based on a combination of Rows from Different Columns

Using Duplicate Row Filter to Identify Value closest to 0