Subscribe Bookmark RSS Feed

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

saitcopuroglu

Community Trekker

Joined:

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

  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
chungwei

Staff

Joined:

Jun 23, 2011

I think the Update command will do what you want.

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

saitcopuroglu

Community Trekker

Joined:

Sep 29, 2014

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

Sent from my iPhone