Using a formula on rows with the same group

[tbrewski123]

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

[benakesh · Accepted solution]

Hi @tbrewski123 ,

After summarize  join  to data to add min/max values to all records.