RE: Invalid Row Number Error

Question

Hi,

I was just wondering about this error I got when I ran my script:

Invalid Row Number{92} in access or evaluation of 'Subscript' , colInstructions[q]

The value of q never reaches 92 so I'm not sure where that number came from, or is 92 in relation to something else? Just for some background information I created a new column to which I'm assigning the value of a cell from another data table (colInstructions[q]).

Any help would be appreciated.

MichelleG · Answer

When you create the new table, it has 0 rows. You need to add some rows to it before you can write data to the first row.

ENTHU · Answer

I am stuck with a similar problem.

I have a string in the list and trying to assign it to the row of a data table. I get an erroe saying - "Cannot set value for column beacuse row number is invalid".

Param = {};
Param = Concat items({A, B, C,D}, " ");

dt = New Table( "RAWDATA" );

dt<< New Column( "Line", Character);
Column(dt,"Line")[1] = Param;

txnelson · Answer

If you add a new column to an existing data table, the column will have the same number of rows as the data table the new column is being added to.   JMP data tables do not have different number of rows for different columns.  They may have missing values or blank values for character columns, but all columns will have the same number of rows.  If you need to add additional rows, you can use "Add Rows()" function.  See:

Help==>Scripting Index==>Data Table==>Add Rows