topic Re: JSL Query Table: Strange result in Discussions

JSL Query Table: Strange result

monir — Tue, 06 Feb 2024 15:11:15 GMT


dirLoc=Pick Directory("Select a directory", "my directory");
			fileList = Files In Directory(dirLoc);
			dt1 = open(dirLoc || fileList[1]);
			dt1 << Select Where( :Amount>=1000 );
			x=dt1<<Subset(Output Table Name("T1"));
			Close(dt1, NoSave);
			show(N Row(x));
			x << Save("my directory\t1.jmp");

Greetings!

I am trying a simple query with a sample data file. The query returns right set of results if there is any record satisfying the condition in "Where" clause. But, in case, there exist no record satisfying the condition, it returns all the records where expected result is an empty set. Even, when I try to see how many records (N Row()) in the resultant set, it shows the count of total records.

Thanks for any suggestion and please let me know if I am missing anything.

Re: JSL Query Table: Strange result

txnelson — Tue, 06 Feb 2024 16:16:06 GMT

I would handle this by checking to see if any rows were selected, and if so, then do the subset, and if not, then print out a message.

dirLoc = Pick Directory( "Select a directory", "my directory" );
fileList = Files In Directory( dirLoc );
dt1 = Open( dirLoc || fileList[1] );
dt1 << Select Where( :Amount >= 1000 );
If( Length( dt1 << get selected rows ) > 0,
	x = dt1 << Subset( Output Table Name( "T1" ) );
	Close( dt1, NoSave );
	Show( N Row( x ) );
	x << Save( "my directory\t1.jmp" );
,
	Show( "no rows selected" )
);

Re: JSL Query Table: Strange result

monir — Tue, 06 Feb 2024 16:54:55 GMT

Hi Jim,
Thanks for your quick reply. Actually, I am trying to concatenate the results, of the query, from multiple tables. Let me try your suggestion. Please share if you have any thoughts on that.

Thanks again!