In JMP need column data as list

zainilmin

I am trying to get the column data as list in jmp. The following is the table.

State Capital

NJ     Trenton

NY    Albany

TX     Austin

I need the list of capital {'Trenton', 'Albany', 'Austin'}. Also i need to loop through list. Please suggest available options.

ian_jmp

If dt is a reference to your data table, then 'myList = Column(dt, 'Capital') << getValues' will put the values into myList. To loop over these values, do 'For(i=1, i<=NItems(myList), i++, Print(myList))'.