cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
JMP is taking Discovery online, April 16 and 18. Register today and join us for interactive sessions featuring popular presentation topics, networking, and discussions with the experts.
Choose Language Hide Translation Bar
HSS
HSS
Level IV

Some glitch in the script. Script works 70% of times and 30% of times, I get error -- "Could not find column in access ........"

Hello guys,

I have a part of a script which some time does not work and throw an error -- " could not find column in access or evaluation of 'Column' , Column/*###*/("Core_BR.Res.(Ohms)") "

 

In the script, I am just renaming columns and in fact, I thought it is related to the size of the table so I have included "Wait(0)" after each column rename command. But no good luck.

Script is like this --

----------------------------------------------

 


dt = Data Table( "STP_DATA" );
Wait( 0 );

dt = Data Table( "STP_DATA" );
Wait( 0 );
Column( "Core_BR.Res.(Ohms)" ) << Set Name( "Core_BR" );
Wait( 0 );
Column( "Rdr.Iso.(Ohms)" ) << Set Name( "Rdr_Iso" );
Wait( 0 );
Column( "Rdr.Res.(Ohms)" ) << Set Name( "Rdr_Res" );
Wait( 0 );
Column( "Rdr_Htr.Res.(Ohms)" ) << Set Name( "Rdr_Htr_Res" );
Wait( 0 );
Column( "TAD.Iso.(Ohms)" ) << Set Name( "TAD_Iso" );
Wait( 0 );
Column( "TAD.Res.(Ohms)" ) << Set Name( "TAD_Res" );
Wait( 0 );
Column( "Wtr.Iso.(Ohms)" ) << Set Name( "Wtr_Iso" );
Wait( 0 );
Column( "Wtr_Htr.Iso.(Ohms)" ) << Set Name( "Wtr_Htr_Iso" );
Wait( 0 );
Column( "Wtr_Htr.Res.(Ohms)" ) << Set Name( "Wtr_Htr_Res" );
Wait( 0 );
Column( "Wtr_I1.Res.(Ohms)" ) << Set Name( "Wtr_I1_Res" );

 

------------------------------------------------------------------------------------------------------

And the error I get is ---

Hari_0-1591876524912.png

 

-----------------------------------------------------------------------------

The thing is, I am not getting this error evrey time. Script works fine 7/10 times but throw error otherwise.

If I active this table (by clicking it) and then run the script, it works 100%. Which means somehow my "dt= Data table (....)" is not refreshing oe recalling  the table or somthing like that !

Any help.

Thanks, Hari

1 ACCEPTED SOLUTION

Accepted Solutions
txnelson
Super User

Re: Some glitch in the script. Script works 70% of times and 30% of times, I get error -- "Could not find column in access ........"

Try changing all of your name setting statements from this structure:

Column( "Core_BR.Res.(Ohms)" ) << Set Name("Core_BR");

to

Column( dt, "Core_BR.Res.(Ohms)" ) << Set Name("Core_BR");

It will force JMP to go to the data table referenced by "dt" 

Jim

View solution in original post

2 REPLIES 2
txnelson
Super User

Re: Some glitch in the script. Script works 70% of times and 30% of times, I get error -- "Could not find column in access ........"

Try changing all of your name setting statements from this structure:

Column( "Core_BR.Res.(Ohms)" ) << Set Name("Core_BR");

to

Column( dt, "Core_BR.Res.(Ohms)" ) << Set Name("Core_BR");

It will force JMP to go to the data table referenced by "dt" 

Jim
HSS
HSS
Level IV

Re: Some glitch in the script. Script works 70% of times and 30% of times, I get error -- "Could not find column in access ........"

Working fine after this change. Hopefully will not face the issue again. Many thanks "Nelson".