I am trying to run a for loop to categorize several columns of data. Out of the 3 or 4 columns, the column with the highest value dictates a category for that entire row. I tried using this formula in a new column to no avail. For reference I am using a subset of data that I later saved as it's own individual file.
Any help as to why the script or formula isnt working is much appreciated. I admit, I was a bit lost when trying to write the script, so I think it is a bit far off from what it should be. I linked the file but I had to remove the first column of the data table for privacy issues.
JMP is getting confused because you are using a column name reference (:Linked Subset) as a table variable. Also you can clean up your if statements using only one IF. I'm not sure if this is exactly what you want but it might give you some hints to get you closer to your goal.
Thanks for clarifying! I tried replacing (:Linked subset) with (dt) in the formula but it did not output any categories for the designated column. I also tried your cleaned up version but it still did not work. Any ideas why there is still an issue with the formula?