cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
JMP is taking Discovery online, April 16 and 18. Register today and join us for interactive sessions featuring popular presentation topics, networking, and discussions with the experts.
Choose Language Hide Translation Bar
saitcopuroglu
Level IV

Saving and replacing a data table with an existing newly generated one

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" ) ),

  Update,

  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;

2 REPLIES 2
chungwei
Staff (Retired)

Re: Saving and replacing a data table with an existing newly generated one

I think the Update command will do what you want.

dtagencystay << Update( With( Data Table( "REALDATA" ) ) );

saitcopuroglu
Level IV

Re: Saving and replacing a data table with an existing newly generated one

Thank you, but unfortunately update command does not bring the additional rows and columns from the second table.

Sent from my iPhone