Hi Team, I have one column with decimal values. I want to create 2 new columns using this column where on column has MAX and other MIN. 0.1178Apples0.0651Apples0.0336Apples0.0291Apples0.0433Apples0.0558Apples0.0091Apples0.0852Apples0.0854Apples0.119Orange0.0592Orange0.0535Orange0.0432Orange0.0406Orange0.0466Orange-0.007Orange0.0942Orange0.119Orange Thanks

MIN MAX Column

Hi Team,

I have one column with decimal values.

I want to create 2 new columns using this column where on column has MAX and other MIN.

0.1178	Apples
0.0651	Apples
0.0336	Apples
0.0291	Apples
0.0433	Apples
0.0558	Apples
0.0091	Apples
0.0852	Apples
0.0854	Apples
0.119	Orange
0.0592	Orange
0.0535	Orange
0.0432	Orange
0.0406	Orange
0.0466	Orange
-0.007	Orange
0.0942	Orange
0.119	Orange

Thanks

Input

Common Use Cases

In Database

In-Database

Accepted answers

Aaron_Harter

Hi @JDong,

You can use the Summarize tool to create these new fields. You can create overall Min & Max values to append to your data table, or group by the Type, then Join back to your data table to get the Min & Max for each:

2020-04-16 data prep sample.yxmd

All comments

Aaron_Harter

Hi @JDong,

2020-04-16 data prep sample.yxmd

RolandSchubert

Hi @JDong ,

I guess, you want the MIN and MAX of Field1 for each entry in Field2. The MIN/MAX values can be found using a Summarize tool, you can join the result on [Field2] then.

I've attached a sample workflow. Let me know, if it works for you,

Best,

Roland

MinMax.yxmd

JDong

Hi,

In the actual scenario I have more than 30 columns.

Can I know how the join will work ?

Thanks

Quick Links

This months top contributors

SophiaF 432

AkimasaKajitani 390

mceleavey 388

mbarone 337

michael_weaver 335