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!
Solved! Go to Solution.
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
Hey @dataminer! I built a workflow with random data I created. The key was to Transpose the data first. See if this helps!