I have been trying to solve the equivalent to a Bin Packing algorithm in Alteryx!
I am trying to use the First Fit decreasing algorithm to sort through the data (around 185 bins initially)
This is where you sort the bins into descending order (of mass in this instance) and try to pour the contents into as few bins as possible by iterating through each bin and pouring it into the first bin with the capacity to hold it! All of my bins have the same capacity and you have to pour the whole thing out.
However I am really struggling with making it loop through conditions whilst then adding/ removing columns and getting out a result!
Has anyone got any idea how I can do this, or any other ways of solving this problem in Alteryx??
