nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

AsymptoticCos

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.

Accepted answers

All comments

jthi

Could you post what you have tried?

AsymptoticCos

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.

jthi

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));
);

AsymptoticCos

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.

txnelson

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 ) )
);