Subscribe Bookmark RSS Feed

Wrong Split Columns with different numbers of Split By rows

motj

Community Trekker

Joined:

Sep 1, 2014

I have measured 15 samples on two days. 4 measurements on day1 and 8 on day2. Now I want to split the data on 2 columns, Day1 and Day2.

The simplified data looks like this:

SampleDayResult
A10.125
A20.135
A20.145
B10.258
B20.256

I want the table to look something like this:

SampleDay1Day2
A0.1250.135
A0.145
B0.258

0.256

Instead I get this:

SampleDay1Day2
A0.1250.135
B0.1580.145
B*0.256

So B in row 2 is connected to both an A and a B value...

If I group by Sample it looks like this:

SampleDay1Day2
A0.1250.145
B0.2580.256

The numbers are correctly assigned to samples and days but I lost row 2 data from the original table.

Is my thinking wrong?

Is there a way to do this?

1 ACCEPTED SOLUTION

Accepted Solutions
Solution

JMP needs another piece of information to make the split the "right" way as is obvious to us.  I think you will find that if you add in a column for the measurement number ("rep")  then split on day and then group by the sample and the rep you will get what you are looking for.

2 REPLIES
Solution

JMP needs another piece of information to make the split the "right" way as is obvious to us.  I think you will find that if you add in a column for the measurement number ("rep")  then split on day and then group by the sample and the rep you will get what you are looking for.

motj

Community Trekker

Joined:

Sep 1, 2014

Thanks. I got it working.