topic Re: Searching Column name in Discussions

Searching Column name

Jackie_ — Fri, 09 Jun 2023 19:55:49 GMT

Hi,

I need to search the column names which has the string "fo" in it and select those column in the Y,Columns.

How do I include this in JSL?

Any help on this would be very much appreciated

Thanks,

Jack

Re: Searching Column name

jthi — Thu, 02 Sep 2021 15:15:34 GMT

Here is an example where all columns containing SS are added to dialog:

Names Default To Here(1);
dt = Open("$SAMPLE_DATA/Water Treatment.jmp");
colList = dt << Get Column Names("String");
a = Filter Each({value}, colList, Contains(value, "SS"));
obj = dt << Explore Outliers(Y(Eval(a)));
obj << Relaunch Analysis;
obj << Close Window();

Re: Searching Column name

Jackie_ — Thu, 02 Sep 2021 15:23:15 GMT

Many Thanks @jthi

I am not sure if JMP 15 supports Filter Each command. I tried the script and it's giving me an error

Re: Searching Column name

jthi — Thu, 02 Sep 2021 15:33:33 GMT

It is a new feature in JMP16.

You will have to use For loop to get the same result in JMP15.

Something like this:

filteredCols = {};
For(i = 1, i <= N Items(colList), i++,
	If(Contains(colList[i], "SS"), Insert Into(filteredCols, colList[i]))
);

Re: Searching Column name

Jackie_ — Thu, 02 Sep 2021 16:08:26 GMT

I want to select and delete those particular rows. How can I include in the jsl script?

Names Default To Here(1);
dt = Open("$SAMPLE_DATA/Water Treatment.jmp");
colList = dt << Get Column Names("String");


filteredCols = {};
For(i = 1, i <= N Items(colList), i++,
	If(Contains(colList[i], "SS"), Insert Into(filteredCols, colList[i]))
);

dt << Explore Outliers(Y(Eval(filteredCols)),

Show only columns with outliers( 1 )
,Quantile Range Ouliers

	
);

Re: Searching Column name

jthi — Thu, 02 Sep 2021 17:03:59 GMT

I think Scripting Index can get you quite close:

I wouldn't generally suggest deleting rows in JMP, hiding and Excluding is usually better option.

Re: Searching Column name

Jackie_ — Wed, 08 Sep 2021 16:10:05 GMT

Happy Wednesday @jthi ,

I was attempting to add another contain statement to filter all the columns containing the string "SE" but it didn't seem to work as expected.

I added Contains(colList[i], "SE") in the if loop Any thoughts?

Names Default To Here(1);
dt = Open("$SAMPLE_DATA/Water Treatment.jmp");
colList = dt << Get Column Names("String");


filteredCols = {};
For(i = 1, i <= N Items(colList), i++,
	If(Contains(colList[i], "SS"), 
	Contains(colList[i], "SE"),
	
	Insert Into(filteredCols, colList[i]))
);
obj = dt <<
Explore Outliers(
	Y((Eval(filteredCols) )));
obj << Tail Quantile( 0.1 );
obj << Quantile Range Outliers;
obj<< Select Rows(All);

Thanks,

Jack

Re: Searching Column name

txnelson — Wed, 08 Sep 2021 16:43:54 GMT

This needs to be an OR clause

If(Contains(colList[i], "SS") |
	Contains(colList[i], "SE"),
	Insert Into(filteredCols, colList[i])
);