Help Needed! Incomplete Details when using SPLIT column

switzal87

Hello JMP community!

I need help figuring out what seems to be the problem when I Split a column of the following Data Table:

My raw data is as shown:

Data Table 1 (Raw Data)

Take note that I have 2 types of Design : D1 and C1. 

I Split this data by "STEP" and "Shift" as the splitted column.Rema. Unexpectedly, I am getting the output table as shown below:

 

Output Table

Take note that in the Output table, "Design" column. D1's were missing.

 

Can anyone point out what could cause to this? I am using JMP 13 version . Thanks in advance!

 

gzmorgan0

Jim (txnelson) provided you the solution to your problem.  This is just an added hint. The data looks like a within wafer (litho, implant, test ?) experiment. Your problem is the most commonly made mistake with Split. As Jim noted, you need a unique group specification. Each defined group gets 1 row.  

 

I am guessing based upon the portion of the table you displayed that this might be the specification you might need using JSL.  If you are doing this via the user interface, specify the columns accordingly.  If each object "gets" all 3 steps, then use this:

dt << Split(
	Split By( :Step ),
	Split( :Shift ),
	Group(:expNum, :WAFERNUM, :Design, :Object, :tgt)
	remaining columns( drop all )
);