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

[#1]

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.

[#2]

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" ), 
					
);

[#3]

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}

[#4]

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

[#5]

Its a column. It is ok like this?

[#6]

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) );
);

[#7]

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

[#8 · Accepted solution]

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.