MIN MAX Column

[JDong]

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

[Aaron_Harter · Accepted solution]

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:

 

[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

[JDong]

Hi,

In the actual scenario I have more than 30 columns.

Can I know how the join will work ?

Thanks

[RolandSchubert]

One column you want to calculate MIN/MAX and 29 additional columns with "keys" (product, attributes)? You'll have to join on all key fields (and include them in the Summarize tool). If you provide a sample file or the field list (e.g. from Select tool) it's easier to explain.