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
JMP2TMW
Level I

How to stack as a matrix? Or some other function to achieve this?

Hi, I am new to JMP. I have a chellenge while scripting to stack values as shown in the first table below to the values in the second table. How can I arrage this?

dateSP_topSP_BottomCoating_topCoating_bottomReading_topReading_bottom
D1S1S2C1C2R1R2
D2S3S4C3C4R3R4

 

datelocationSPCoatingReading
D1TopS1C1R1
D1BottomS2C2R2
D2TopS3C3R3
D2BottomS4C4R4
1 ACCEPTED SOLUTION

Accepted Solutions
jthi
Super User

Re: How to stack as a matrix? Or some other function to achieve this?

First stack with something like this

jthi_0-1686770546810.png

next split the label column to two using text to columns

jthi_1-1686770576875.png

 

jthi_2-1686770590494.png

then recode issues in Label 2 (some are Bottom and some bottom) by grouping them

then you can split this

jthi_3-1686770716950.png

into this

jthi_4-1686770725805.png

If you have JMP16+ I think these steps will be captured by enhanced log (or workflow if JMP17 and you wish to create one)

jthi_5-1686770806094.png

 

-Jarmo

View solution in original post

2 REPLIES 2
jthi
Super User

Re: How to stack as a matrix? Or some other function to achieve this?

First stack with something like this

jthi_0-1686770546810.png

next split the label column to two using text to columns

jthi_1-1686770576875.png

 

jthi_2-1686770590494.png

then recode issues in Label 2 (some are Bottom and some bottom) by grouping them

then you can split this

jthi_3-1686770716950.png

into this

jthi_4-1686770725805.png

If you have JMP16+ I think these steps will be captured by enhanced log (or workflow if JMP17 and you wish to create one)

jthi_5-1686770806094.png

 

-Jarmo
JMP2TMW
Level I

Re: How to stack as a matrix? Or some other function to achieve this?

Awesome. Your solution gives exatly what I wanted. Thank you so much!