There is no any alerting message even though original[raw] data disappear in 'tables/split' platform

IkjuShin

This is our customer's question, I checked his question but I could not find the reason why.

1. He splited his data [data.jmp]

   -splited by : param

   -split columns : value

   -group : other 3 variables

2. After split, the result is data after split.jmp

 

Without any alerting message (i.e. some part of your data could be disappeard), one row of raw data was 

   disappeard. I think that  raw data must not disappear without proper user alerting.

  Is this bug, error of JMP ? or Is there any reason

 

data.jmp

data after split.jmp

brady_brady

Hello Ikju,

 

As Phil mentions, :param, :Lot#, :Dcc and :process code are not unique in the table. There are only 11 combinations of these, but there are 12 rows in the table, so a row must be omitted in the split table. It appears from my experimenting around a bit that the LAST row occurring in the original table, for each combination of :param, :Lot#, :Dcc and :process code (that is, the set of "Split By" and "Group" variables) will be kept.

 

 

 

I think a warning message that rows will be dropped is a good idea, and for fastest resolution of that, the customer should contact technical support.

 

In the meantime, the customer can perform a quick check to see whether data will be lost in the split: have him or her use the Summary platform on the original table, using the "Split By" variable and "Group" variables that he or she wants to use in the Split operation, as the "Group" variables in the Summary dialog. If the Summary table has fewer rows than the original table has, data will be lost in the split.

 

For example, in this case he or she would use Summary with :param, :lot#, :Dcc and :process code as the Group variables. When the summary table appears, it has 11 rows, but the original table had 12 rows, so 1 row of data will be lost if a split is performed using the same variables. Data will be lost for any combination of :param, :lot#, :Dcc and :process code where N Rows does NOT equal 1 in the Summary table.