Use match or contains ?

sbidwe — Fri, 09 Jun 2023 22:11:24 GMT

Request some help with scripting the "Output" column.

I have a list of Sr IDs allocated to different events and need the resulting output column where LAB T0 event is matched to specific Event

Would be obliged for the help. I have attached the excel file for the above screenshot.

Thanks

Re: Use match or contains ?

txnelson — Tue, 20 Apr 2021 02:45:34 GMT

Given a data table that looks like this

JMP provided the following script as I interactively when through the steps to create your required output

// Clear row selection
Data Table( "Example File" ) << Clear Select;


// Data table summary
// → Data Table( "Subset of Untitled 9 By (Sr ID, Event)" )
Data Table( "Example File" ) << Summary(
	Group( :Sr ID, :Event ),
	Freq( "None" ),
	Weight( "None" ),
	Link to original data table( 0 )
);

// Select matching cells
Data Table( "Example File By (Sr ID, Event)" ) <<
Select Where( :Event == "LAB_T0" );


// Delete selected rows
Data Table( "Example File By (Sr ID, Event)" ) <<
Select Where( :Event == "LAB_T0" ) << Delete Rows;


// Delete column: N Rows
Data Table( "Example File By (Sr ID, Event)" ) << Delete Columns( :N Rows );


// Change column name: Event → Output
Data Table( "Example File By (Sr ID, Event)" ):Event << Set Name( "Output" );


// Update data tables
Data Table( "Example File" ) << Update(
	With( Data Table( "Example File By (Sr ID, Event)" ) ),
	Match Columns( :Sr ID = :Sr ID )
);

Re: Use match or contains ?

sbidwe — Fri, 23 Apr 2021 16:50:01 GMT

Thanks much Jim

topic Use match or contains ? in Discussions

Use match or contains ?

Re: Use match or contains ?

Re: Use match or contains ?