882637_zh-CN

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);
);