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
Shinohara
Level I

How to separate different data set from one column

Hi, 

I have a table that contains several data set as shown below. How can I save those level 0, level 1, level 2... to different data tables with jsl?

Shinohara_0-1580164412201.png

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
txnelson
Super User

Re: How to separate different data set from one column

Basically you just need to use the Split platform

     Tables==>Split

However, before that you need to create a new column called Level and use the formula to create new values that represent the levels.

Here is the formula, based upon your data

If (Row()==1, theLevel=0);
If(left(:bits,5)=="Level" then theLevel++);
theLevel;

Once this new column is created, then go to the

     Tables==Split

and Specify

     Level as the Split By Clumn

     Vt and Bits as the Split Columns

You will need to do a bit of clean up, getting rid of the rows that have Raw Curve and Level as values, and you will need to change the columns from character to numeric.

 

Jim

View solution in original post

1 REPLY 1
Highlighted
txnelson
Super User

Re: How to separate different data set from one column

Basically you just need to use the Split platform

     Tables==>Split

However, before that you need to create a new column called Level and use the formula to create new values that represent the levels.

Here is the formula, based upon your data

If (Row()==1, theLevel=0);
If(left(:bits,5)=="Level" then theLevel++);
theLevel;

Once this new column is created, then go to the

     Tables==Split

and Specify

     Level as the Split By Clumn

     Vt and Bits as the Split Columns

You will need to do a bit of clean up, getting rid of the rows that have Raw Curve and Level as values, and you will need to change the columns from character to numeric.

 

Jim

View solution in original post

Article Labels

    There are no labels assigned to this post.