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

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

saitcopuroglu — Tue, 24 Mar 2015 12:49:25 GMT

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;

chungwei — Thu, 26 Mar 2015 19:14:18 GMT

I think the Update command will do what you want.

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

saitcopuroglu — Fri, 27 Mar 2015 05:30:08 GMT

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

Sent from my iPhone