Empty rows are inserted while publishing the data
search cancel

Empty rows are inserted while publishing the data


Article ID: 16658


Updated On:


CA Test Data Manager (Data Finder / Grid Tools)


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?


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


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.