topic Re: Skip below lines if a table is empty inside a for loop in Discussions

Skip below lines if a table is empty inside a for loop

AT — Thu, 08 Mar 2018 18:42:19 GMT

Hi, I have the following script which is inside a for loop. I like to continue the loop if table mydt is empty and skip lines below it.

I appreciate your help. Thanks

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

mydt = Data Table( dt5 );

if((is empty(mydt)), continue());

mydtsummary = Data Table( dt5 ) << Summary(

Group( :BoardNo ),

Max( :starttime ),

statistics column name format( "stat of column" )

);

mydt << Update(

With( Data Table( mydtsummary ) ),

Match Columns( :BoardNo = :BoardNo ),

Add Columns from Update table( :Max of starttime )

);

mydt << select where( :starttime == :Max of starttime ) << invert row selection;

mydt << delete rows;

mydt << delete columns( "Max of starttime" );

Close( mydtsummary, nosave );

Close(mydt,save);

Re: Skip below lines if a table is empty inside a for loop

cwillden — Thu, 08 Mar 2018 19:35:06 GMT

Why not just reverse the logic using "!" and stick all those lines in your if statement?

If( !Is Empty( mydt ),
	mydtsummary = Data Table( dt5 ) << Summary(
		Group( :BoardNo ),
		Max( :starttime ),
		statistics column name format( "stat of column" )
	);

	mydt << Update(
		With( Data Table( mydtsummary ) ),
		Match Columns( :BoardNo = :BoardNo ),
		Add Columns from Update table( :Max of starttime )
	);

	mydt << select where( :starttime == :Max of starttime ) << invert row selection;

	mydt << delete rows;

	mydt << delete columns( "Max of starttime" );

	Close( mydtsummary, nosave );
	Close( mydt, save );
);

Re: Skip below lines if a table is empty inside a for loop

AT — Thu, 08 Mar 2018 21:31:35 GMT

Thanks for quick feedback and solution. I tried it but I get an error in the update section.

missing argument{8} in access or evaluation of 'Data Table' , Data Table/*###*/(mydtsummary)

mydt << Update(

With( Data Table/*###*/(mydtsummary) ),

Looks like it is processing Update section when mydt is empty and it should not. Thanks

Re: Skip below lines if a table is empty inside a for loop

cwillden — Fri, 09 Mar 2018 16:51:29 GMT

What are you using the Is Empty() function to do? If it is to check if the table itself has no data in it, you are using this function incorrectly. It will tell you if the variable mydt (not the data table it references) has no value or has the empty value. If you want to check if the data table has nothing in it, then do something like N Row(mydt) == 0 as your logical check.

Re: Skip below lines if a table is empty inside a for loop

AT — Fri, 09 Mar 2018 18:49:42 GMT

Thanks Cameron. The issue is not whether the table is empty or has no value. the issue, if the condition is true, I want to skip all the lines below that and go to the next for loop index.

if (condition = True,

....

... skip all below

...

);

Thanks.

Re: Skip below lines if a table is empty inside a for loop

txnelson — Fri, 09 Mar 2018 18:52:58 GMT

If( condition == true,

Break();

);

Re: Skip below lines if a table is empty inside a for loop

AT — Fri, 09 Mar 2018 21:21:29 GMT

Thanks Jim.