cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Try the Materials Informatics Toolkit, which is designed to easily handle SMILES data. This and other helpful add-ins are available in the JMP® Marketplace
Choose Language Hide Translation Bar
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

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.

Probe_PE
Level I

Re: Creating JMP script for data manipulation

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

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

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?