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?
Go to Solution
Basically you just need to use the Split platform
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++);
Once this new column is created, then go to the
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.
View solution in original post
There are no labels assigned to this post.