Sep 29, 2014
Everything goes fine but the update ddata table does not want to replace the original AgencyStayLBL. It ends up as "AgencyStayLBL 2".
Could someone tell me what am I doing wrong please?
dtagencystay = Open( "/Users/..../AgencyStayLBL.jmp" );
dtrealdata = Open( "/Users/.../AgencyStayREALDATA.xls" );
dtagencystay << Join(
With( Data Table( "REALDATA" ) ),
Suppress formula evaluation( 0 ),
By Row Number,
Output Table( "AgencyStayLBL", Replace Table )
dtagencystay << Sort( By( :SalesDate ), Order( Ascending ), Replace Table );
dtagencystay << Select Where( :StayType == 4 );
dtagencystay << delete rows;
Jun 23, 2011
I think the Update command will do what you want.
dtagencystay << Update( With( Data Table( "REALDATA" ) ) );
Thank you, but unfortunately update command does not bring the additional rows and columns from the second table.
Sent from my iPhone