Max value in a column

deep_215
deep_215 Registered Posts: 9 ✭✭✭

Hi,

My requirement is to find the max value of a column and the add that max value will be populated against each row in the dataset as a new column.

For e.g.

Existing dataset

col1col2col3
123ABC
117GDFT
125HDG
135HDI

here 35 is the max value for col2. hence it needs to get populated in a new column. new dataset will be as below

col1col2col3col4(New Column)
123ABC35
117GDFT35
125HDG35
135HDI35

please help me to get away with this problem. Thanks in advance

Regards,

Deepak

Best Answer

  • deep_215
    deep_215 Registered Posts: 9 ✭✭✭
    Answer ✓

    I used window recipe and was able to fulfill my requirement. i did sorting in descending order on required column and then took first value of that column from aggregate list. with this final result was achieved

Answers

Setup Info
    Tags
      Help me…