Liz_s, yes these are referring to column numbers. From the JMP Main Menu, select Help > Books > Scripting Guide and go page 439 (or near by). This is a section in chapter 9 Data Tables, section 1, Working with Data Table Objects, topic Accessing Data Values . Read that entire section for alternate methods to access and assign data values. Comment: The key to your task was to find which decision column contained "Matriculated" for each row. Looping 22+ times for each row is a lot of nesting. The key here to learn more is to use the Help > Scripting Index > Functions to learn about Contains. Contains( list|string, matching string) returns the first position where it is found. Note: Loc() returns all positions in a list or matrix where the matching value is found. Understanding that dt[row, c1::cn] where columns c1 through cn are character will return a list of the table values. Contains() will find the position (k), so this will be the correct position for the organization column. The key is to "know your tools" how to access and assign and know your functions. Good luck with your journey learning JMP.
... View more