我希望能夠在拆分資料表時建立多個回應列。 這將允許使用者看到列中有多個您沒有刪除的值(目前它需要第一個值?基於順序的值?)。
我可以相當輕鬆地編寫自己的自訂分割平台腳本,但我更願意使用 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);
我認為這很可能是拆分平台中的新 Col 列錶框(如果不可能,請選中復選框,但在我看來這不是一個好的選擇)。