Pablo
September 21, 2018, 2:56pm
1
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:
Please, can someone help me?
thanks!!
Use group by node grouping by SKU and use aggregation function Max.
1 Like
Pablo
September 21, 2018, 3:09pm
3
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
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
Pablo
September 21, 2018, 3:39pm
5
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…
system
Closed
September 28, 2018, 3:39pm
6
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.