Jmp Script Problem

unknown

I am running the following JMP script, joining some files and creating new columns, towards building a combined final report. When I run this script, the last line generates the 'Temp1' table, with all the column names, but no data. If I break the script before this line and run the script from the last line onwards separately, it works fine. Wondering if any one could tell me why I am having to break the script into two.

Thanks,

Ravi

Data Table( "File1" ) << Join(With( Data Table( "File7" )), Merge Same Name Columns, By Matching Columns( :Die = :Die ), Output Table( "FileA" ));

New Column("Die_loc", Character, Nominal, Formula(Substr(:Die, 14, 7)));

Data Table( "File2" ) << Join(With( Data Table( "File8" )), Merge Same Name Columns, By Matching Columns( :Die = :Die ), Output Table( "FileB" ));

New Column("Die_loc", Character, Nominal, Formula(Substr(:Die, 14, 7)));

Data Table( "File3" ) << Join(With( Data Table( "File9" )), Merge Same Name Columns, By Matching Columns( :Die = :Die ), Output Table( "FileC" ));

New Column("Die_loc", Character, Nominal, Formula(Substr(:Die, 14, 7)));

Data Table( "FileA" ) << Join(With( Data Table( "FileB" )), Merge Same Name Columns, By Matching Columns( :Die_loc = :Die_loc ), Output Table( "Temp1" ));

ms

One possibility is that the evaluation of formulas in the new columns has not finished before the final Join(). Try if inserting Eval Formula in each New Column() helps.

New Column("Die_loc", Character, Nominal, Formula(Substr(:Die, 14, 7)), Eval Formula);