community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE

Row selection based on max sales

Meteoroid

Hello

 

I am in the middle of a workflow I got the below data set:

DATA       
OLD ITEMLOCATIONINVACTIVITYNEW ITEMLOCATIONSALESACTIVITY
123UK15Obsolete456USA20Active 
123UK15Obsolete789CANADA100Active 
123UK15Obsolete987Russia50Active 

 

And what I want is the data to give the best option among the above 3 based on maximum amount of sales in order to move inventory over. 

Result        
OLD ITEMLOCATIONINVACTIVITYNEW ITEMLOCATIONSALESACTIVITY
123UK15Obsolete789CANADA100Active 

 

Thanks 

Meteoroid

MaxSales.jpg

 

There may be a more elegant solution (I'm new to this myself!), but this simple workflow will save the results to a second tab in the XL file which contains your data.

 

Attached both.

Highlighted
Quasar

@ACARDIN while the above solution from @Giles would work, there's a bit simpler route to get there. 

 

 

Row Match data.PNG

 

You just need to ensure that your sample tool is grouped on the old item field, assuming you have more than one unique value in the actual dataset.

 

Meteoroid

Figured there'd be a more streamlined method! ;)

Meteoroid

This looks good but please can I have the workflow.

Meteoroid

Thanks for this Giles. This actually works perfect with the above example but when I add to a 16000 lines record it doesn't work at all.

Quasar

Attached is the workflow I was referencing.

Meteoroid

Neil yeahhh it worked thank you very much :)

Labels