Hello all
Having a unique problem to solve here, i was wondering if someone here can help me...
So i have two columns of data, which looks like this. the left side is how it is now, i want to make it look like how it is on the right side. so the values are different for a certain set of repeating column one entries. i want to add the values up until it reaches 70, if it crosses 70 then it should be a separate entry.
example: if it is A-20,A-30,A-20 then it should become A-70 but if it is B-20,B-40,B-20 then it should become B-60 and B-20 because 80>70.
Is there any function/tool i can use in alteryx to get this done ?
