topic Working with matching values from lists to tables in Discussions

Working with matching values from lists to tables

Aam_jmp — Tue, 03 Jul 2018 15:56:02 GMT

I have two lists extracted from a data set, one list contains column names and another, certain values extracted (one value from each column) based on certain conditions.

List1 = {Wweight, O2 Uptake.......};

List2 = {38,59.08.....};
After this step, the user gets a JMP table like the one below as an output with options whether to remove the value extracted by the script or not:

The user either removes the value from the main table or decides to keep it.
What I am further trying to do is:
1) I run a script to find minimum values, and if the value matches the value against that column (which means that the user decided to keep the value) I want to get the next minimum value
2) If not, I extract the minimum value as is.

dt = current data table();

colNamesList = dt << get column names( string, numeric, continuous );
nc = N Items( colNamesList );

Names = {};
MinVals = {};
MinValList = {};

For( i = 1, i <= nc, i++,
	Cols = Column( dt, i );

	Insert into(Names, colNamesList[i]);
	MinValue = Col Min( Cols );
	Insert into(MinVals, MinValue);
	MinRows = dt << get rows where( As Column( Cols ) == MinValue );
	Insert into(MinValList, MinRows[1]);
	);
	
	

dt1 = new table( "Data", 
	New Column( "Column Name", character, nominal, values(Names)),
	New column( "Min value", numeric, nominal, values( MinVals)),
	New Column( "Row Number", expression, nominal, values( MinValList ));
	
);

How can I match the values to check for each row whether the user has removed the value or not?

//Second Part

For( i = 1, i <= nc, i++,
	Cols = Column( dt, i );
	colMin = Col Min( Cols );
	//If value in Col min is equal to value in MinValue, then skip that value and choose the next minimum value, else add that value to a new list

Re: Working with matching values from lists to tables

cwillden — Tue, 03 Jul 2018 17:27:39 GMT

You could do something like this:

For( i = 1, i <= nc, i++,
	Cols = Column( dt, i );
	colMin = Col Min( Cols );
	//If value in Col min is equal to value in MinValue, 
	//then skip that value and choose the next minimum value, else add that value to a new list
	
	//get the corresponding row in the table (if it doesn't align with the index of your loop)
	row_tmp = dt1 << Get Rows Where(:Column Name == Cols); 
	if(Min value[row_tmp] == colMin,
		//Insert Code to look for next smallest value
	)
)

row_tmp gets the row in dt1 where the value of Column Name matches the current column name in Cols.

Re: Working with matching values from lists to tables

Aam_jmp — Tue, 03 Jul 2018 18:15:56 GMT

@cwillden

I get this output for row_tmp

Re: Working with matching values from lists to tables

cwillden — Tue, 03 Jul 2018 18:46:15 GMT

I probably should have included a "[1]" on the end of that definition for row_temp. Sorry, I'm shooting from the hip a bit here without actually running this through JMP with an example data table. Make sure to wrap the whole thing in parentheses before adding the [1].

(row_tmp = dt1 << Get Rows Where(:Column Name == Cols))[1];

You probably are also comparing to a name object rather than a string. To get the column name as a string, try this:

Cols = Column(dt, 1) << Get Name;

I think with both of those changes, it should work.

Re: Working with matching values from lists to tables

Aam_jmp — Tue, 10 Jul 2018 19:41:40 GMT

@cwillden I'm sorry, it still doesn't work for me. I just want to check if Min Values are still present in the columns of Linnerud table. But I am unable to make that script to work.