This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I am in the middle of a workflow I got the below data set:
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.
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.
@ACARDIN while the above solution from @Giles would work, there's a bit simpler route to get there.
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.
Figured there'd be a more streamlined method! 😉
This looks good but please can I have the workflow.
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.
Attached is the workflow I was referencing.
Neil yeahhh it worked thank you very much 🙂