I believe this is a bug because I can run the same script on my Mac using JMP4
and the script works as expected.
-RLC
>
> From: <roncross@cox.net>
> Date: 2006/03/07 Tue PM 03:35:10 EST
> To: <jmp-l@lists.biostat.wustl.edu>
> CC: <roncross@cox.net>
> Subject: [jmp-l] How to write script to split table sequentially
>
> 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
>
>
|