topic Re: Extract Max number from a column and feed it to a for loop in the same jsl script in Discussions

Extract Max number from a column and feed it to a for loop in the same jsl script

AsymptoticCos — Wed, 29 May 2024 16:34:23 GMT

My JSL script has 3 parts. In the first part, I am creating a numeric column (Column A) with 100 rows filled with random integers between 50-1000.

In the 2nd part, I am extracting the max number in Column A and storing it to a variable i.

In the 3rd part, I am using i to create a for loop that creates i number of new columns in the same table. How can I do this?

It seems I can store the data in i but the for loop is not running.

Re: Extract Max number from a column and feed it to a for loop in the same jsl script

jthi — Wed, 29 May 2024 16:52:50 GMT

Could you post what you have tried?

Re: Extract Max number from a column and feed it to a for loop in the same jsl script

AsymptoticCos — Wed, 29 May 2024 16:57:39 GMT

Here is the max value extraction from Column A.

X = Eval(Col Max(:Name("Column A")));

Then when I use that as, for (i=1, i<=X ...

This for loop does not run. I checked that X is reporting the right number.

Re: Extract Max number from a column and feed it to a for loop in the same jsl script

jthi — Wed, 29 May 2024 17:02:55 GMT

You didn't post your code so difficult to say what is wrong. Here is working example

Names Default To Here(1);

dt = New Table("",
	Add Rows(100),
	New Column("ColumnA", Numeric, Continuous, Formula(Random Integer(50, 1000)))
);

max = Col Max(Column(dt, "ColumnA"));

For(i = 1, i <= max, i++,
	dt << New Column(Char(i), Numeric, Continuous, Set Each Value(i));
);

Re: Extract Max number from a column and feed it to a for loop in the same jsl script

AsymptoticCos — Wed, 29 May 2024 17:07:22 GMT

This code has the same problem as my code. When I run your code it does not create the columns that should have been created by the for loop. I am using JMP 14 so a bit older version.

Re: Extract Max number from a column and feed it to a for loop in the same jsl script

jthi — Wed, 29 May 2024 17:10:26 GMT

Are you getting error message? Are your columns being created but they have incorrect values? You said that for loop doesn't run but now it isn't creating columns (those are most likely separate issues). If you add Show(i); inside your loop does it print those values correctly to log?

Names Default To Here(1);

dt = New Table("",
	Add Rows(100),
	New Column("ColumnA", Numeric, Continuous, Formula(Random Integer(50, 1000)))
);

max = Col Max(Column(dt, "ColumnA"));

For(i = 1, i <= max, i++,
	Show(i);
);

Re: Extract Max number from a column and feed it to a for loop in the same jsl script

AsymptoticCos — Wed, 29 May 2024 17:15:35 GMT

When I run this, I only see /*; in the log.

Re: Extract Max number from a column and feed it to a for loop in the same jsl script

jthi — Wed, 29 May 2024 17:23:44 GMT

As I don't have access to JMP14 I have to just guess what could be different.

Maybe loop isn't run at all -> add debug print for max

Names Default To Here(1);

dt = New Table("",
	Add Rows(100),
	New Column("ColumnA", Numeric, Continuous, Formula(Random Integer(50, 1000)))
);

max = Col Max(Column(dt, "ColumnA"));
Show(max);

For(i = 1, i <= max, i++,
	Show(i);
);

other debug case, try loop without the table

Names Default To Here(1);
max = 10;

For(i = 1, i <= max, i++,
	Show(i);
);

If JMP14 did have Debugger (and you can get that working as that might not be that easy) you could also try that

Re: Extract Max number from a column and feed it to a for loop in the same jsl script

txnelson — Wed, 29 May 2024 19:23:22 GMT

Here is a real simple example......

Names Default To Here( 1 );
dt = 
// Open Data Table: Blood Pressure.jmp
// → Data Table( "Blood Pressure" )
Open( "$SAMPLE_DATA/Blood Pressure.jmp" );

dt << New Column( "A", formula( Random Integer( 50, 1000 ) ) );

i = Col Max( dt:A );

For( k = 1, k <= i, k++,
	dt << New Column( "col" || Char( k ) )
);