Hi All,
Currently, I have a request where I need to group the data on the ID level and create a new column "Calc_Min_hour" which will take the minimum hour value from the "Min_Hour" column and have that pasted to the new column "Calc_Min_hour".
For Ex:
ID Min_Hour
1 11
1 11
1 13
2 8
2 9
2 10
2 8
Now based on the above data, the Minimum value of column "Min_Hour" is 11 for ID 1 and 8 for ID 2. So, I need a new column "Calc_Min_Hour", with the data shown below;
Result:
ID Min_Hour Calc_Min_Hour
1 11 11
1 11 11
1 13 11
2 8 8
2 9 8
2 10 8
2 8 8
Can some one help me in achieving this?
Solved! Go to Solution.
Hi @Aparanjith ,
This is a simple matter of using the sum tool to find the min value grouped by ID, then joining back.
Hope this helps.
M.