cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Try the Materials Informatics Toolkit, which is designed to easily handle SMILES data. This and other helpful add-ins are available in the JMP® Marketplace
Choose Language Hide Translation Bar
Paul06
Paul06
Level I

Get column names that has particular value

Created: Jan 4, 2021 07:49 PM  |  Last Modified: Jun 10, 2023 4:24 PM (3825 views)

Hi, 

 

I just started using jmp at work and trying to learn JSL. I am trying to write a script to get the column names where the row value =1. For example, the table shows values of 0 and 1 under different IMCX columns and I want to find out which column has the value =1 in each row and store under a new column called IMC. In the first row,  column IMC 4 has 1 so I manually enter IMC4 under IMC. There are more than 5000 rows in the tables. Thank you for the help. 

 

Paul06_0-1609807451271.png

 

0 Kudos
10 REPLIES 10
Paul06
Paul06
Level I

Re: Get column names that has particular value

Jan 5, 2021 11:16 AM (2541 views)  |  Posted in reply to message from txnelson 01-04-2021
Thanks you for your time and help. I am sorry I did not state the problem clearly. In each row, there is only one instance of 1 under a column and I need to pick out the column name and save under a new column.
0 Kudos