我希望能够在拆分数据表时创建多重响应列。 这将允许用户看到您没有删除的列中有多个值(目前它首先出现?基于顺序的值?)。
我可以相当轻松地编写自己的自定义 Split 平台脚本,但我更愿意使用 JMP 自己的平台。 下面是带有“常规”拆分的示例脚本以及我想要的(已经可以使用组合列来完成,但没有脚本是一件麻烦事)。
Names Default To Here(1);
dt = New Table("MEAS_DATA",
Add Rows(10),
Compress File When Saved(1),
Set Cell Height(19),
New Column("ID", Numeric, "Continuous", Format("Best", 12), Set Values([1, 1, 2, 2, 3, 3, 4, 4, 5, 5])),
New Column("Process",
Character,
"Nominal",
Set Values(
{"MEASUREMENT_A", "MEASUREMENT_B", "MEASUREMENT_A", "MEASUREMENT_B", "MEASUREMENT_A", "MEASUREMENT_B", "MEASUREMENT_A",
"MEASUREMENT_B", "MEASUREMENT_A", "MEASUREMENT_B"}
)
),
New Column("Value", Numeric, "Continuous", Format("Best", 12), Set Values([1, 2, 1, 4, 7, 1, 2, 6, 2, 1])),
New Column("Error", Character, "Multiple Response", Set Values({"0", "0", "1", "0", "2", "1", "0", "0", "0", "0"})),
New Column("Status", Numeric, "Continuous", Format("Best", 12), Set Values([1, 1, 0, 1, 0, 0, 1, 1, 1, 1])),
New Column("Time", Numeric, "Continuous", Format("Best", 12), Set Values([1, 2, 1, 2, 1, 2, 1, 2, 1, 2]))
);
dt_split = dt << Split(Output table("Split"),
Split By(:Process), Split(:Value), Group(:ID), Sort by Column Property);
//suggestion... directly from split? I could also fairly easily script this
//multiple response only supports character data, but doesn't really matter in my use cases (usually)
dt_mult_resp = dt << Split(
Output table("Multiple_response_split"),
Split By(:Process),
Split(:Value, :Error, :Status, :Time),
Group(:ID)
);
dt_mult_resp << Combine Columns(columns(:Error MEASUREMENT_A, :Error MEASUREMENT_B), Column Name("Error"), Delimiter(","));
dt_mult_resp << Delete Columns(:Error MEASUREMENT_A, :Error MEASUREMENT_B);
dt_mult_resp << Combine Columns(columns(:Status MEASUREMENT_A, :Status MEASUREMENT_B), Column Name("Status"), Delimiter(","));
dt_mult_resp << Delete Columns(:Status MEASUREMENT_A, :Status MEASUREMENT_B);
dt_mult_resp << Combine Columns(columns(:Time MEASUREMENT_A, :Time MEASUREMENT_B), Column Name("Error"), Delimiter(","));
dt_mult_resp << Delete Columns(:Time MEASUREMENT_A, :Time MEASUREMENT_B);
我认为这很可能是 Split 平台中的新 Col List Box(如果不可能,则选中该框,但我认为这不是一个好的选择)。