How can I add colums into an output table?

carias0316

Hi,

I joined two tables by matching two columns, this generates a new data table,  but now I have to add a new column with a formula into the output table generated after a join the previous ones, but for some reason I can't make it work. This it what I tried so far

Data Table( dt1 ) << Join(

With( Data Table( dt2 ) ),

By Matching Columns( :XNative = :XNative, :YNative = :YNative ),

Copy formula(0),

Suppress formula evaluation(0),

Drop multiples( 0, 0 ),

Include NonMatches(1, 1),

Preserve main table order( 1 ),

Output Table Name( "Contour Plot")));

Wait(2);

data table("Contour Plot") << New Column("subs", Numeric, Continuous, Format("Best", 8), Formula(:T1 of 0413 - :T1 of 0310));

or

dt=Data Table( dt1 ) << Join(

With( Data Table( dt2 ) ),

By Matching Columns( :XNative = :XNative, :YNative = :YNative ),

Copy formula(0),

Suppress formula evaluation(0),

Drop multiples( 0, 0 ),

Include NonMatches(1, 1),

Preserve main table order( 1 ),

Output Table Name( "Contour Plot"))):

Close("Contour Plot", save ("C:\Users\cjariasr\Desktop\cp.txt"));

dt << New Column("subs", Numeric, Continuous, Format("Best", 8), Formula(:T1 of 0413 - :T1 of 0310));

Please help!

Thanks

txnelson

One can not completely trouble shoot your code, given that you have not provided what the dt1 and dt2 table names are. I also suggest that you use pointers to the data tables rather than having to deal with all of the code necessary to use the data table's name.  The code below should work with your data, providing that you place into the dt1= and dt2= the names of the two data table. the code also changes the name of the "T1" column in the second data table, so that in your formula for the new column you are creating, you can use the names from the data tables, rather than having to come up with the names JMP will generate when it finds columns from the different tables that have the same name.

Names Default To Here( 1 );

dt1 = Data Table( "first data table" );

dt2 = Data Table( "second data table" );

dt2:t1 << set name("dt2t1");

dt3 = dt1 << Join(

       With( dt2 ),

       By Matching Columns( :XNative = :XNative, :YNative = :YNative ),

       Copy formula( 0 ),

       Suppress formula evaluation( 0 ),

       Drop multiples( 0, 0 ),

       Include NonMatches( 1, 1 ),

       Preserve main table order( 1 ),

       Output Table Name( "Contour Plot" )

);

dt3 << New Column( "subs", Numeric, Continuous, Format( "Best", 8 ), Formula( :T1  - :dt2t1 ) );