topic Issue in JMP16 with Get Rows Where in Discussions

Issue in JMP16 with Get Rows Where

mosiph_ct — Fri, 09 Jun 2023 22:11:10 GMT

Hi,

I have the following piece of code that works in earlier JMP versions but stops working in JMP 16.

//*****Set Working Directory*****//
PCName = Get Environment Variable("COMPUTERNAME");
WorkingPath_Settings_File = Get Path Variable("DOCUMENTS") || "WorkingPath_Settings.xlsx";
dt_WorkingPath = Open(WorkingPath_Settings_File, invisible);
rowindex_list = dt_WorkingPath << Get Rows Where(:PCName == PCName);
If(NItems(rowindex_list) == 0,
	rowindex = 1,
	rowindex = rowindex_list[1]
);
WorkingPath = dt_WorkingPath:WorkingPath[rowindex];
Close(dt_WorkingPath, NoSave);

The error occurs at line:

rowindex_list = dt_WorkingPath << Get Rows Where(:PCName == PCName);

Error:

Name Unresolved: PCName at row 1 in access or evaluation of 'PCName' , :PCName/*###*/

Thank you for your help.

Re: Issue in JMP16 with Get Rows Where

txnelson — Fri, 16 Apr 2021 00:53:18 GMT

I found that my xlsx file was not reading in the data with row 1 as the column headers. I changed the open statement to the below, and then the code worked without error

dt_WorkingPath = Open( WorkingPath_Settings_File, invisible,
	Worksheets( "Sheet1" ),
	Use for all sheets( 1 ),
	Concatenate Worksheets( 0 ),
	Create Concatenation Column( 0 ),
	Worksheet Settings(
		1,
		Has Column Headers( 1 ),
		Number of Rows in Headers( 1 ),
		Headers Start on Row( 1 ),
		Data Starts on Row( 2 ),
		Data Starts on Column( 1 ),
		Data Ends on Row( 0 ),
		Data Ends on Column( 0 ),
		Replicated Spanned Rows( 1 ),
		Replicated Spanned Headers( 0 ),
		Suppress Hidden Rows( 1 ),
		Suppress Hidden Columns( 1 ),
		Suppress Empty Columns( 1 ),
		Treat as Hierarchy( 0 ),
		Multiple Series Stack( 0 ),
		Import Cell Colors( 0 ),
		Limit Column Detect( 0 ),
		Column Separator String( "-" )
	) );

Re: Issue in JMP16 with Get Rows Where

mosiph_ct — Fri, 16 Apr 2021 02:19:07 GMT

It works great now. Thank you.