DI Run Table Loader Only If Table Isnt Empty

mike73 — Tue, 30 Jan 2018 12:47:17 GMT

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.

Re: DI Run Table Loader Only If Table Isnt Empty

LinusH — Tue, 30 Jan 2018 14:21:09 GMT

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.

topic Re: DI Run Table Loader Only If Table Isnt Empty in SAS Data Management

DI Run Table Loader Only If Table Isnt Empty

Re: DI Run Table Loader Only If Table Isnt Empty