Subscribe Bookmark RSS Feed

In JMP need column data as list

zainilmin

Community Trekker

Joined:

Jun 22, 2015

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.

1 REPLY
ian_jmp

Staff

Joined:

Jun 23, 2011

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))'.