duplicate rows

Hi all, im trying about of removing duplicates of a table.

For example, two colums of my table are like this:

sku supplier
A 1
B 2
C 1
A 3

As you can see, sku A appears two times. when the value of sku is duplicated, i need to delete de row where
supplier has the lowest value.

so the resluts need to be like this:

sku supplier
B 2
C 1
A 3

Please, can someone help me?
thanks!!

Use group by node grouping by SKU and use aggregation function Max.

1 Like

thanks!! thats works, but the i dont now how to keep the values of the rest of the table.

For example, if the table is:

sku supplier price orders
A 1 15 100
B 2 20 98
C 1 20 45
A 3 8 100

the result should be:

sku supplier price orders
B 2 20 98
C 1 20 45
A 3 8 100

Using group by node grouping by SKU and use aggregation function Max
it returns this results

sku supplier
B 2
C 1
A 3

but i dont know how to keep the other columns…

Thanks!

Use joiner to join back to original table by SKU and Supplier fields including necessary fields.

2 Likes

tbank you a lot!!!

I did not know that the joiner node can be used with 2 columns…
before i was trying to do a join betwen sku (after the groupby) and the orignal table but that brings back the duplicate values too…

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.