cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Check out the JMP® Marketplace featured Capability Explorer add-in
Choose Language Hide Translation Bar
Paul06
Level I

Get column names that has particular value

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

 

10 REPLIES 10
Paul06
Level I

Re: Get column names that has particular value

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.