Retrieve a Column Group

SpannerHead — Wed, 26 Mar 2025 18:33:49 GMT

I have columns held within groups and I want to be able to reference the group to which each column belongs as a string while I iterate on them. Is that possible?

Re: Retrieve a Column Group

jthi — Wed, 26 Mar 2025 18:40:57 GMT

Use << Get Column Group Names to get list of the names and then << Get Column Group to get the list of columns

Edit: If you wish to have strings, loop over the list of columns using Transform Each and then convert them to strings using << Get Name

Names Default To Here(1);
dt = Open("$SAMPLE_DATA/Cities.jmp");
dt << group columns("xy", {:X, :y});
dt << group columns("pollutants", :Ozone :: :Lead);

colrefs = dt << get column group("xy");

colnames = Transform Each({colref}, colrefs,
	colref << get name
);


show(colrefs, colnames);

topic Retrieve a Column Group in Discussions

Retrieve a Column Group

Re: Retrieve a Column Group