Share your ideas for the JMP Scripting Unsession at Discovery Summit by September 17th. We hope to see you there!
Choose Language Hide Translation Bar
Highlighted
Probe_PE
Level I

Creating JMP script for data manipulation

Hi i want to create a JSL for following table 

title1Title2Title3stack1stack2stack3..............stack(n-1)stackn
ACE0.55.0100..........2045.65
BDF1.521055.35.........2241

 

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.

4 REPLIES 4
Highlighted

Re: Creating JMP script for data manipulation

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.

Learn it once, use it forever!
Highlighted
Probe_PE
Level I

Re: Creating JMP script for data manipulation

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

Highlighted

Re: Creating JMP script for data manipulation

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

 

Screen Shot 2019-04-25 at 6.46.19 AM.png

Learn it once, use it forever!
Highlighted
Probe_PE
Level I

Re: Creating JMP script for data manipulation

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? 

Article Labels

    There are no labels assigned to this post.