11576_en-US

liliconcom

Saving and replacing a data table with an existing newly generated one<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />

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;

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

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