BookmarkSubscribeRSS Feed
mike73
Calcite | Level 5

I would like to run a table loader transformation only if the source table is not empty. I've tried playing around with Conditional Start but I cannot get anything to work.

 

Reason:

We have a source table coming from SQL which is having minor issues currently and our SAS source table will sometimes contain 0 rows, a job on auto scheduler runs and replaces destination table with these 0 rows and this causes problems later on (VA etc). Until this other issue is sorted we would like to only run this loader if rowcount > 0.

 

 Capture.PNG

1 REPLY 1
LinusH
Tourmaline | Level 20

I think you need som kind of user written code that check the source for no of records. You could put this in a User Written node, and then use Conditional Start to check the result from there, or just terminate the SAS session directly.

Data never sleeps

sas-innovate-wordmark-2025-midnight.png

Register Today!

Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.


Register now!

How to connect to databases in SAS Viya

Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 1 reply
  • 855 views
  • 0 likes
  • 2 in conversation