Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
I would like to use a recipe that can distribute rows in different ranges based on values of a single column.
I would like to do following. Y is the column. I would like to distribute the rows in following manner
I want to do that so that i can run the below formula afterwards.
Var X (Remaining quantity)
IF (15=<Y<31) { X = A - B}
ELSE IF
(31<=Y <= 35 ) {
X = C - B}
ELSE IF
(40<=Y <= 45) {
X = D - B}
ELSE IF
(Y>=50) {
X==0
}
In both steps, you can use the Formula processor in the Prepare recipe using nested if statements: if(condition, value if true, value if false)
If you are simply classifying into quartiles, you can also use a Window recipe, provide a sorting column and compute 4 quantiles (see image).
I hope this helps.
In both steps, you can use the Formula processor in the Prepare recipe using nested if statements: if(condition, value if true, value if false)
If you are simply classifying into quartiles, you can also use a Window recipe, provide a sorting column and compute 4 quantiles (see image).
I hope this helps.
Thank you @Manuel - It works