topic Re: how to add a new formula with JSL？ in Discussions

how to add a new formula with JSL？

TONYMA — Mon, 01 May 2017 07:37:36 GMT

all i use the samlpe which named thickness.JMP to produce a new file by summary。 but i don not know to how to add one formula with JSL in summary table。

Re: how to add a new formula with JSL？

TONYMA — Mon, 01 May 2017 07:39:15 GMT

Re: how to add a new formula with JSL？

TONYMA — Mon, 01 May 2017 07:40:05 GMT

Re: how to add a new formula with JSL？

ih — Mon, 01 May 2017 18:40:16 GMT

To create the summary table first and then add a formula column to it, save a reference to the table when you create it:

//Save reference to the newly created summary table.
dt = Data Table( "Thickness" ) << Summary( Group( :Bar ), N, Mean( :Thickness 01 ) );

//Send a message to the new table to create the new column.
dt <<  New Column( "New formula column",
	Character,
	Formula( 
		If( :Name( "Mean(Thickness 01)" ) > 0.04,
			"normal",
			"thin"
		)
	)
);

Re: how to add a new formula with JSL？

TONYMA — Thu, 04 May 2017 13:38:43 GMT

i want to calculate " Thickness 01/N rows ". JSL is below, that is right? dt << New Column( "New formula column", Character, Formula( :Name( "Thickness 01) / :Name( "N rows"));

Re: how to add a new formula with JSL？

Mark_Bailey — Thu, 04 May 2017 14:16:48 GMT

Your formula involves division. It requires numeric data columns for this compuation. Your result is set up for a new column with the character data type. If that is what you want, then wrap the division inside the Char() function to satisfy the data type.

Re: how to add a new formula with JSL？

ENTHU — Tue, 05 Feb 2019 20:25:30 GMT

I am stuck with a simialr issue. I perform division operation in one column and then need to transpose the table.Running into issue while I try to do this.

dtIn << New Column("Max Size ",Character,format("best",8),Formula(
:Name("Max Size") = (2500/:Min Size))
);


//check for empty columns and delete if any
dt = Current Data Table();
names = dt << Get Column Names();
dt1 = dt << Missing Data Pattern(columns(Eval(names)), invisible);
n = N Row(dt1);
For(i = N Col(dt), i >= 1, i--,
If(Col Sum(Column(dt1, i + 3)) < n,
Remove From(names, i)
)
);
Try(dt << delete columns(names));
Close(dt1, nosave);
//Get all coulmn names
allcolnames = dt << get column names(string);
show(allcolnames);
for (i = 1, i <= nitems(allcolnames), i++,
column(dt, allcolnames[i]) << data type(Character,"Nominal");
);

But getting an error becuase of the formula -

Cannot convert argument to a number [or matrix] 1 times At rows: 2 Operation: Divide, 2500 / /*###*/:Min Size/*###*/
Formula evaluation errors have been ignored

Re: how to add a new formula with JSL？

txnelson — Tue, 05 Feb 2019 19:59:16 GMT

I am assuming that you have a pointer to your data table called

dtInput

but not one called

dtIn

Re: how to add a new formula with JSL？

ENTHU — Tue, 05 Feb 2019 20:26:15 GMT

That's a typo. I have pointer to data table called dtIn.