Determining Max Value of Columns

dataminer

I have a workflow that cross tabs my data into a dataset that has 1800 columns with a double in each column except for the first column which was the label. I need to check to see if any of these columns are greater than a certain threshold. If they are greater than a certain threshold then a new column at the end will be true. The cross tab will give me different amount of columns based on my data, so this cannot be hard coded in a formula with a whole bunch of IF statements. Any thoughts would be greatly appreciated!

Thanks!

jdunkerley79

Could you transpose the data (or do before cross-tabbing) and use a summarise tool grouping by the first column to get the max of the other 1800 columns. You can then use a formula tool to 

You can then use a formula tool to create the True/False value. Finally join back to the cross-tabbed data on the first column to add the additional column you wanted.

If you can post a sample of data happy to build a sample