Hello All... Not new to Alteryx but just learning marcos. I would appreciate your help on this problem. Its kind of like a Monte Carlo simulation but much more simple. I have a table with dimensions (length,width,height) and weight. I want to take a random sample of this table until I reach a dimensional threshold (l+w+h) to be determined. I would like to add the weights of each row in the sample and then repeat until the table is empty. Any dimensions that are already over threshold are filtered out already. The outputs will be number of items in groups and total weight. Input table looks like this:
Item | HEIGHT | LENGTH | WIDTH | WEIGHT |
a | 11 | 14.25 | 11.25 | 29.37 |
b | 7 | 26 | 16 | 9.22 |
c | 7 | 26 | 16 | 31.83 |
d | 10 | 21.5 | 17 | 45.92 |
e | 15 | 21 | 18 | 30.78 |
f | 12 | 20 | 14 | 11.49 |
g | 12 | 20 | 14 | 3.7 |
h | 15 | 21 | 18 | 24.29 |
i | 13 | 24.25 | 16.25 | 8.33 |
j | 11 | 14.25 | 11.25 | 4.34 |
k | 10 | 21.5 | 17 | 13.1 |
l | 12 | 20 | 14 | 44.16 |
m | 5.31 | 24.88 | 6.18 | 4.1 |
n | 8.5 | 15.98 | 10.51 | 11.07 |
o | 15 | 21 | 18 | 25.38 |
p | 7 | 26 | 16 | 5.56 |
q | 15 | 21 | 18 | 15.56 |
r | 7 | 26 | 16 | 4.63 |
s | 14.21 | 15.2 | 14.61 | 12.63 |
t | 11 | 14.25 | 11.25 | 11.11 |
u | 15 | 21 | 18 | 21.61 |
v | 9.37 | 20.55 | 15.59 | 13.75 |
w | 4.09 | 21.61 | 9.02 | 3.64 |
x | 4.9 | 21.25 | 16.25 | 1.9 |
y | 15 | 21 | 18 | 45.35 |
z | 6 | 21 | 15 | 3.17 |
I have been looking at the tutorials and other workflows but can't seem to get exactly what I want. Your help is greatly appreciated!
Thanks!
J
Solved! Go to Solution.
Works great! I was so close! Thanks for your help!