topic Re: Select column group from a list in Discussions

Select column group from a list

SpannerHead — Fri, 07 Mar 2025 21:53:52 GMT

Using an associative array, I have a list containing the titles of column groups (common). I tried to use select column group with that but it doesn't work as is. What modifications do I need to make for this to work?

dt << select column group( common );

Re: Select column group from a list

SpannerHead — Fri, 07 Mar 2025 22:35:53 GMT

Ignore me! Figured it out. Duh!

For( g = 1, g <= N Items( common ), g++,
    dt << select column group( common[g] )
);

Re: Select column group from a list

jthi — Sun, 09 Mar 2025 15:57:05 GMT

You can also use list with select column group but you have to evaluate it

Names Default To Here(1);

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

groupnames = {"xy", "pollutants"};
Eval(EvalExpr(dt << select column group(Expr(groupnames))));