For example I have the table below:
I want to create a recipe that will keep only the row with the lowest value in column C, so the result would be:
Any clue? thanks in advance
Solved! Go to Solution.
Hi @Gustavo Castanheira? , that's a great question.
I'd assume this table can have many different groups of values in columns A+B, and for each group, you'd like the minimum value in column C.
So, to do so - the most straightforward way would be to use the group-by transformation.
You can access it either through the toolbar:
Or through the drop-down menu of each column:
Or via the "new step"/"search transformation" buttons:
there you can search for "group by":
You'd want to group by the columns you're aggregating by (in our case, these are columns A+B), and the value to generate would be the desired minimum value of column C. So we'll be using the min() function.
This is how it would look like - and the preview here shows how the table is being changed to the desired output:
See that we chose the option for "as new table". If we would've chosen the "as new column(s)" option, the new aggregated value would just be added as a new column to the original table, like so:
I hope this helps.
Thanks,
Amit.
It really helps a lot. Thanks Amit. God bless.
Pleasure's all mine =]