01-30-2018 07:47 AM
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.
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.
01-30-2018 09:21 AM
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.