Find columns containing a specific value

SpannerHead — Tue, 24 Feb 2026 20:30:41 GMT

I need to compile a list of all columns containing a specific value eg. 999

Re: Find columns containing a specific value

jthi — Tue, 24 Feb 2026 20:44:04 GMT

This should give some ideas

Names Default To Here(1);

dt = Open("$SAMPLE_DATA/Probe.jmp");

contcols = dt << Get Column Names(Continuous, String);

c = Filter Each({colname}, contcols,
	n = Loc(dt[0, colname], 9999);
	N Items(n) > 0;
);

Show(c);

topic Find columns containing a specific value in Discussions

Find columns containing a specific value

Re: Find columns containing a specific value