BookmarkSubscribeRSS Feed
Choose Language Hide Translation Bar
saitcopuroglu
Community Trekker

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;

0 Kudos
2 REPLIES 2
chungwei
Staff

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

0 Kudos
saitcopuroglu
Community Trekker

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

0 Kudos