topic Re: If statement not working in jsl in Discussions

If statement not working in jsl

Resheffink1 — Tue, 10 Sep 2024 07:08:27 GMT

Hi all.

Can you please check what is the problem with my if statement? I want to run several jsl commands in case the condition is true (in my case, that the spec file name is as written in the code) but it does not work.

Everything else is working fine, just the if statement is not.

My JMP version is 18

dt = Current Data Table();
dt << Select Columns( :PARAMETER );
dt << Text To Columns( delimiter( "_" ) );
dt << delete columns( :PARAMETER 1 );
If( :SPECFILE == "MS-SMLD",
	:PARAMETER 2 << set name( "Column_name1" );
	:PARAMETER 3 << set name( "Column_name2" );
	:PARAMETER 4 << set name( "Column_name3" );
	:PARAMETER 5 << set name( "Column_name4" );
	:PARAMETER 6 << set name( "Column_name5" ) ;
	,
	If( :SPECFILE == "SMLA", Formula(
		dt << delete columns( :PARAMETER 5 );
		:PARAMETER 2 << set name( "Column_name1" );
		:PARAMETER 3 << set name( "Column_name2" );
		:PARAMETER 4 << set name( "Column_name3" );
		 )
	)
);

Thanks,

Reshef

Re: If statement not working in jsl

jthi — Tue, 10 Sep 2024 07:15:08 GMT

Might be enough if you changed :SPECFILE to SPECFILE (:SPECFILE would (usually) refer to a column).

Re: If statement not working in jsl

Resheffink1 — Tue, 10 Sep 2024 07:20:53 GMT

Hi.

Thanks! but the "SPECFILE" is indeed a column in my jmp table.

Anyway, I tried it and it does not work.

Maybe its what separate the jsl commands in my IF statement?

Or, maybe its impossible to run several jsl commands in one IF statement?

Thanks,

Reshef

Re: If statement not working in jsl

jthi — Tue, 10 Sep 2024 07:42:23 GMT

Then you have to define the Row (Row() = 1; for example) or loop over the rows in your table using For Each Row. The "default" row in JMP is 0 which isn't valid row

Re: If statement not working in jsl

txnelson — Tue, 10 Sep 2024 10:15:06 GMT

If what you are trying to do, is to look at row 1's value in column "SPECFILE" and then make decisions based on it, the JSL below will be what you want

Names Default To Here( 1 );
dt = Current Data Table();
dt << Select Columns( :PARAMETER );
dt << Text To Columns( delimiter( "_" ) );
dt << delete columns( :PARAMETER 1 );
If(
	:SPECFILE[1] == "MS-SMLD",
		:PARAMETER 2 << set name( "Column_name1" );
		:PARAMETER 3 << set name( "Column_name2" );
		:PARAMETER 4 << set name( "Column_name3" );
		:PARAMETER 5 << set name( "Column_name4" );
		:PARAMETER 6 << set name( "Column_name5" );,
	:SPECFILE[1] == "SMLA",
		dt << delete columns( :PARAMETER 5 );
		:PARAMETER 2 << set name( "Column_name1" );
		:PARAMETER 3 << set name( "Column_name2" );
		:PARAMETER 4 << set name( "Column_name3" );
);