Hi all, I have a question on how to split a Table in JMP. I am using JMP 5 on
Windows.
I am having a problem with splitting a JMP table while the original datatable,
dt, is being created. and I hope that this group will be able to help me.
In order to split the table, I am using the following command:
dt<<New Column("Parameter Channel", Character, Nominal, Formula(If( :Channel,
:Parameter || "_CH" || Char( :Channel), :Parameter)))<<New Column("Jack",
Numeric, Continuous, Format("Best", 10), Formula(Num(Word(2, :FieldID,
"-"))))<<New Column("Jane", Numeric, Continuous, Format("Best", 10),
Formula(Num(Word(3, :FieldID, "-"))))<<Split(Col ID( :Parameter), Split(
:Parameter Channel), Group( :FieldID, :Jack, :Jane), Output
Table("mysplittable"), Remaining Columns(Drop All));
When I run the script, I notice that both tables dt and the table that I want
to split (mysplittable) appear to be created at the same time. This results in
table "mysplittable" having missing values in columns Jack and Jane. If I
break out the script and create the original data table first with the new
columns and then I run another script to create the split table mysplittable,
all seems to be ok.
Can anyone fill me in on how to get the script to run sequentially? I want to
create three columns with their values. After that I want to split the table
so that the values are visible under Columns Jack and Jane. I thought that
<<command 1<< command 2<< command 3 ran sequentially, but this doesn't appear
to be the case with data tables.
Thanks
RLC
|