I have a large data set with dozens of different groups. I am trying to use alteryx to normalize/rescale the data in each of the different groups. In the example you can see there are three groups: A,B, and C. I want to apply the following formula to each group rather than the entire data set.
(value - min_value)/(max_value - min_value).
This will give me a value between 0 and 1 for each group. So for group A I would find the min and max (554 and 5804377) and apply the formula. I would want to do the same for B and C. I can use the summarize data tool to get the min and max for each group. But I am not sure how to apply the formula to each group individually. The answer column is what the final output should be once the formula is applied to each group.
Thanks for your help!
| Row | Group | Value | Answer |
| 1 | A | 1321351 | 0.3320 |
| 2 | A | 554 | 0.0000 |
| 3 | A | 65456 | 0.0163 |
| 4 | A | 7534 | 0.0018 |
| 5 | A | 98198 | 0.0245 |
| 6 | A | 3979111 | 1.0000 |
| 7 | A | 19819 | 0.0048 |
| 8 | A | 312354 | 0.0784 |
| 9 | B | 222 | 0.4576 |
| 10 | B | 484 | 1.0000 |
| 11 | B | 1 | 0.0000 |
| 12 | B | 77 | 0.1573 |
| 13 | C | 6465 | 0.0000 |
| 14 | C | 79816 | 0.0075 |
| 15 | C | 9797819 | 1.0000 |
| 16 | C | 64561 | 0.0059 |
| 17 | C | 454454 | 0.0458 |
| 18 | C | 651561 | 0.0659 |
| 19 | C | 651567 | 0.0659 |
| 20 | C | 759879 | 0.0769 |
