Empty rows are inserted while publishing the data

Products

• CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

If I am publishing a datapool (or generator) that is based on data that is not found in the source database, TDM still publishes an empty row.  For example,  if all my columns are using sqllists that rely on a specific account number,  and the account number does not exist.  If I publish to a file,  all I get is a row of empty columns.

Is there a way to tell Datamaker (and the Portal) not to publish the row if the row has no data?

Environment

Release: TDMTDD99000-4.1-Test Data Manager-for Test Data on Demand
Component:

Resolution

There is no way to prevent publishing of a row of data if there was no data found for the row.   This is actually a valid use case for our customers.   If you do not want to have the empty rows in a file,  you can build a post publish action to delete the rows in the publish were no data is found.