Hello,
I want to manipulate a large GC-MS dataset (48 Millions rows) and I get stuck at an intermediate step of data manipulation.
I want to create a new table, through scripting, from an intermediate table Num-Example.jmp here attached (it is a subset of 14 rows of my intermediate table of 340 000 rows = conditions which should lead to the final table of 48 millions rows = condition & data) .
For this subset I need to automatically (through scripting) create a new table containing 2119 rows (this corresponds to row 14 of column Cumulative[A] in Num-Example.jmp) with a column ":ID#" populated with ID# = "1" in the first 131 rows, then ID# = "2" in the next 150 rows, and so on.
ID# = "1" and 131 come from informations in row 1 of Num-Example.jmp (column "ID#" for the ID# and column ":A" for the number of rows to create in the new table).
ID# = "2" and 150 come from informations in row 2 of Num-Example.jmp.
and so on up to last row = 14 (ID# = 14).
Thank you for your help.
Emmanuel
