Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Use the Minimum value of ColumnA and paste to the ColumnB based on group by

Aparanjith
7 - Meteor

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?

2 REPLIES 2
mceleavey
16 - Nebula

Hi @Aparanjith ,

 

This is a simple matter of using the sum tool to find the min value grouped by ID, then joining back.

 

mceleavey_0-1614642894608.png

 

mceleavey_1-1614642923598.png

 

Hope this helps.

 

M.

Qiu
17 - Castor

@Aparanjith 

A bit different approach

CaptureA1.PNG

Labels