cancel
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
dg1
dg1
Level III

If Statement in For Loop Error

Hi! I am having trouble with putting my if statement in my for loop. I want my if statement to evalaute which elements in the array matches the word "Continuous", and store that column's data in a seperate array/list ( a suggestion for the best way to store coloumn data would also be helpful). I'd appreciate any help! Thanks.

Column Data = {};
 for(i= 0, i <= ncol, i++, 
 	if ((Result[i] == "Continuous"),
 		ColumnData = Column(columnName[i])
      );
);

 
3 REPLIES 3
Thierry_S
Super User

Re: If Statement in For Loop Error

Hi, I don't have time to test your script but at first glance I can see a couple of issues:
1) You do not define the table to be used by your script
2) Your call of "ncol" does not refer to any data table
3) You do not define the variable "Result" which you use as an array
4) Reference to a specific column content with "Column (ColumnName [i])" is not likely to work, maybe trying something like just "column[i]" might work better
5) Your assignment to "ColumnData" is not likely to work as you want because you are not appending each column content to the variable "ColumnData"
Thierry R. Sornasse
dg1
dg1
Level III

Re: If Statement in For Loop Error

Names Default To Here( 1 );
dt = Open(Example.jmp");
columnName = dt << Get Column Names (String);
ncol = 4;
Result = {"Continuous", "Continuous", "Categorical", "Continuous") // this is variable 
ColumnData = {};
 for(i= 0, i <= ncol, i++, 
 	if ((Result[i] == "Continuous"), // i am getting an error for this statement
 		ColumnData = Column(columnName[i])
              // i want to store just column data and put it into a matrix, and perform operations on it 

      );
);

Thank you for your quick response. I apologize for not providng enough details earlier. Are you able to tell what is wrong with the code above? I appreciate your help. 

gzmorgan0
Super User (Alumni)

Re: If Statement in For Loop Error

@dg1 ,

 

Try

ColumnData = Column(columnName[i]) << get as matrix