topic Re: Creating JMP script for data manipulation in Discussions

Creating JMP script for data manipulation

Probe_PE — Thu, 18 Apr 2019 23:48:14 GMT

Hi i want to create a JSL for following table

title1	Title2	Title3	stack1	stack2	stack3	..............	stack(n-1)	stackn
A	C	E	0.5	5.0	100	..........	20	45.65
B	D	F	1.52	10	55.35	.........	22	41

for this table i want to create a script

which will create a new table with stacked all columns from stack1 to stack n. then in new table add new column at the end which will put numbers 1,2..25 abd repeat same sequence till end ofthe table.

Re: Creating JMP script for data manipulation

Mark_Bailey — Fri, 19 Apr 2019 12:14:20 GMT

I suggest using the interactive Tables > Stack command to achieve the first desired result. You can then copy the Source table script to a script window. You can easily add a new column to the stacked data table with the << New Column() message. The Repeat() function used with the Index() function should provide the values easy enough.

Re: Creating JMP script for data manipulation

Probe_PE — Thu, 25 Apr 2019 01:19:48 GMT

could not see source table script. how to get that ?

Re: Creating JMP script for data manipulation

Mark_Bailey — Thu, 25 Apr 2019 10:47:19 GMT

The data table that results from the Tables > Stack command should have a table script called Source in the table panel.

Re: Creating JMP script for data manipulation

Probe_PE — Thu, 25 Apr 2019 17:29:00 GMT

Hi thanks. i got my script. but in that script i have all columns names individually. is there a way that i can make a loop out of it?