How to separate different data set from one column

[#1]

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?

[#2 · Accepted solution]

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.