I need to find max and min values of unit price of every item in my table. Please help me out.

My table contains Unit price of every item and each item has multiple transactions. Now, I need to find max and min values of unit price from all the transactions of each item in my table. Please help me out
Thanks in advance…

Hi,

For this task I reccomned to use Groupby node in which you grouip by min an max values.
If you can share some data we can help you with the workflow.

Regards

1 Like

I have tried this but for bothe min and Max aggregations it’s giving me the same output.

Hi,

Which group(s) did you setup up to group on (the first tab in the Gruop by node)?

Yes I got it now. I have taken The Items column in Group(s).Thank you Andrejz

Hi @Nithishreddy27 ,
in the first tab (group) you have to select your grup “Item_description” and this second tab, I think is correct.
You can try it and tell me please.
Regards

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