cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Try the Materials Informatics Toolkit, which is designed to easily handle SMILES data. This and other helpful add-ins are available in the JMP® Marketplace
Choose Language Hide Translation Bar
SpannerHead
Level IV

Concatenating Unique and Nonmissing Data

I have a data table describing the tool history for a series of semiconductor lots.  In some instances, the lots can split and be run across different tools for the same processing step.  In such case, I would like to create a column with each tool concatenated to indicate that > 1 tool was involved.  With a lot of help, I have gotten to the point where I can identify the lots, steps and substeps where > 1 tool was used.  I can transpose the data to get to the tools being nominated in columns but it's still clumsy.  Can I somehow concatenate that to get the unique tools listed.  I also looked at Split but all of the options are not reflected.

 

SpannerHead_1-1734386954050.png

 

 


Slán



SpannerHead
1 ACCEPTED SOLUTION

Accepted Solutions
txnelson
Super User

Re: Concatenating Unique and Nonmissing Data

Here is one way to do it

As Constant(
	dt = Current Data Table();
	start = 5;
	stop = N Cols( dt );
);
Concat Items( Associative Array( dt[Row(), Index( start, stop )] ) << get keys, "/" );

As a strong suggestion, please take the time to go to 

     Help=>JMP Online Help

and read the section on Scripting Guide to familiarize yourself with JSL and scripting

Jim

View solution in original post

3 REPLIES 3
txnelson
Super User

Re: Concatenating Unique and Nonmissing Data

Here is a formula that will work to create your Desired Result column

As Constant( dt = Current Data Table() );
Concat Items( Associative Array( dt[Row(), 0] ) << get keys, "/" );
Jim
SpannerHead
Level IV

Re: Concatenating Unique and Nonmissing Data

txnelson

 

This is a huge step forward.  Is there an easy way to dodge the first 4 columns from the equation?  Columns 5 onwards have the relevant data.


Slán



SpannerHead
txnelson
Super User

Re: Concatenating Unique and Nonmissing Data

Here is one way to do it

As Constant(
	dt = Current Data Table();
	start = 5;
	stop = N Cols( dt );
);
Concat Items( Associative Array( dt[Row(), Index( start, stop )] ) << get keys, "/" );

As a strong suggestion, please take the time to go to 

     Help=>JMP Online Help

and read the section on Scripting Guide to familiarize yourself with JSL and scripting

Jim