topic Re: I am splitting a table and looking to name it something different. in Discussions

I am splitting a table and looking to name it something different.

Hobbi — Sun, 11 Jun 2023 11:28:06 GMT

Hey all,

Hopefully something simple here but I have a JSL where I am taking a table and splitting it. I want to name it something but it keeps giving itself an "Untitled ###" table name. I want to name it "new_table_split"

MOSFET_TLM << Split("new_table_split",
	Split By( :DeviceID ),
	Split( :LotID, :WaferID, :TestLevel, :XLoc, :YLoc, :Rsh, :Rcon ),
	Remaining Columns( Drop All ),
	Sort by Column Property
);

Re: I am splitting a table and looking to name it something different.

Jeff_Perkinson — Fri, 30 Sep 2022 20:51:07 GMT

The argument for naming the table is Output Table().

dt=open("$SAMPLE_DATA\Big Class.jmp");

dt << Split(
	Split By( :sex ),
	Split( :height ),
	Group( :name ),
	Output Table( "my split table" ),
	Remaining Columns( Drop All ),
	Sort by Column Property
);

There are three ways to learn this.

1. Perform the Split interactively, using the option in the Split dialog to name the output table and then examine the Source script in the resulting table.

2. If you have JMP 16 or greater the Enhanced Log window will show you the script.

3. The Help->Scripting Index entry for Split shows the syntax.

Re: I am splitting a table and looking to name it something different.

Hobbi — Sun, 02 Oct 2022 00:22:36 GMT

Thank you very much for the explanations! Very insightful. I tried understanding via the Scripting Index but must've gotten lost in the sauce. I do have JMP 16 and did not know of the Enhanced Log you mentioned.