Keeping header and value of column with higher number

Felipe_Amancio

Hi masters

what would be the easiest solution to keep the value and header of the column with the highest number? see example below

- Original table

ID	USA	Canada	Brazil
001	1000	500	700
002	3000	3500	3200
003	2500	2000	2800

- Expected result

ID	USA	Canada	Brazil	Highest Number	Highest Number Origin
001	1000	500	700	1000	USA
002	3000	3500	3200	3500	Canada
003	2500	2000	2800	2800	Brazil

Thanks

Felipe

apathetichell

assuming substantially more columns:

transpose - ID as key column.

summarize tool - group by ID - max value

join to transpose ID/Value

select tool Name  becomes Highest Number Origin/Max_Value becomes Highest Number

Join to the original datastream ID/ID

If you have only 3 columns use a bunch of IFs.