882637_zh-TW

liliconcom

從父表複製列組

我正在根據父表建立摘要。父表中的列已分組，我想在摘要表中保留這些分組嗎？我已重新命名摘要中的列以使其與父表匹配，這樣可以嗎？

自動化和腳本回覆：從父表複製列組

您是否曾查看過腳本索引（<< 取得列組名稱，<

回覆：從父表複製列組

賈爾莫

確實查過了，但一頭霧水。只好從舊腳本中偷取一部分程式碼。 dt 引用父表，dtbest 引用總表。看來可以了。

Grps = dt << Get Column Groups Names;

For( j = 1, j <= N Items( Grps ), j++,
colrefs={};
colrefs = dt << get column group(Grps[j]);

Group = dtBest << Group Columns(colrefs);
dtBest << rename column group( Group, Grps[j] );
	
);

回覆：從父表複製列組

For Each({groupname}, dt << Get Column Groups Names,
	cols = dt << Get Column Group(groupname);
	dt_new << Group Columns(groupname, cols);
);

Names Default To Here(1);
dt = Open("$SAMPLE_DATA/Cities.jmp");

dt << group columns("xy", {:X, :y}); // for demo purposes
dt << group columns("pollutants", :Ozone :: :Lead); // for demo purposes

dt_summary = dt << Summary(
	Group(:X, :Y, :OZONE, :CO, :SO2, :NO, :PM10, :Lead, :city),
	Freq("None"),
	Weight("None"),
	Link to original data table(0),
	output table name(
		"Summary of Cities grouped by X, Y, OZONE, CO, SO2, NO, PM10, Lead, city"
	)
);
dt_summary << Ungroup Columns(); // for demo purposes, they are grouped by default 

For Each({groupname}, dt << Get Column Groups Names,
	cols = dt << Get Column Group(groupname);
	dt_summary << Group Columns(groupname, cols);
);