topic Re: "Specified Column not found in data table" in Fit Model using JSL in Discussions

"Specified Column not found in data table" in Fit Model using JSL

tomerFire — Thu, 11 Oct 2018 12:51:21 GMT

I have a script that makes a Fit Model from a table I import.

My problem is that I get this error when accessing the data.

"Specified Column not found in data table.{4759} in access or evaluation of 'List' , {/*###*/data:T_VALUE}"

When I try to access the column through "Show" I get good results:

"data:T_VALUE = 1;"

My code:

data = Open( "C:/Users/taviad/Desktop/Sheet1.jmp" );


					Show(data:T_VALUE);
					
					model = data << Fit Model(
					Y( data:T_VALUE ),
					Effects(
						data:x,
						data:y,
						data:z,
						data:c
					),
					Personality( "Standard Least Squares" ),
					Emphasis( "Minimal Report" ),
					Run(),
					Where( data:b == "param1" & data:n == "param2" ),
					
				);

Thanks.

Re: "Specified Column not found in data table" in Fit Model using JSL

txnelson — Thu, 11 Oct 2018 13:00:07 GMT

It is possible that JMP has not finished opening your data table, when it is going ahead and running the Fit Model. If that is the case, by adding in a Run Formulas request will force JMP to complete the Open() function, and should fix the issue.

data = Open( "C:/Users/taviad/Desktop/Sheet1.jmp" );
data << run formulas;
					
model = data << Fit Model(
	Y( data:T_VALUE ),
	Effects( data:x, data:y, data:z, data:c ),
	Personality( "Standard Least Squares" ),
	Emphasis( "Minimal Report" ),
	Run(),
	Where( data:b == "param1" & data:n == "param2" ), 
					
);

Re: "Specified Column not found in data table" in Fit Model using JSL

tomerFire — Thu, 11 Oct 2018 13:05:14 GMT

Hi, thanks for the answer.
I tried it and I got the same error:

data:T_VALUE = 1;

Specified Column not found in data table.{4759} in access or evaluation of 'List' , {/*###*/data:T_VALUE}

Re: "Specified Column not found in data table" in Fit Model using JSL

Mark_Bailey — Thu, 11 Oct 2018 13:36:15 GMT

Is T_VALUE a data column or a table variable? Fit Least Squares requires a data column in the Y role.

Re: "Specified Column not found in data table" in Fit Model using JSL

tomerFire — Thu, 11 Oct 2018 13:59:58 GMT

Its a column. It is ok like this?

Re: "Specified Column not found in data table" in Fit Model using JSL

Mark_Bailey — Thu, 11 Oct 2018 14:59:02 GMT

I just don't undestand the error: "T_VALUE = 1". That makes it look like a scalar value, not a column.

Re: "Specified Column not found in data table" in Fit Model using JSL

gzmorgan0 — Thu, 11 Oct 2018 15:00:35 GMT

The log messages you reported look strange.

"Specified Column not found in data table.{4759} in access or evaluation of 'List' , {/*###*/data:T_VALUE}" this is not the error message I get if I specify a column that does not exist. This looks like an error message when you have a list specified for Y

When I try to access the column through "Show" I get good results: "data:T_VALUE = 1;" This will occur when T_VALUE is a table variable and no column with that name exists
This is the results of a Show when data has a column with that name is "data:T_VALUE = .;"

Just in case your column name is read in with a CR or tab you might want to try the script below, it removes leading and trailing spaces and tabs and line feeds and carriage returns(new line)

for(i=1, i<=ncol(data), i++,
	column(data,i) << set name( Trim( column(data,i) << get name) );
);

Re: "Specified Column not found in data table" in Fit Model using JSL

tomerFire — Thu, 11 Oct 2018 16:10:05 GMT

I managed to solve it be resaving the data on a new file. I dont know what was the problem but the original file was not good.