Empty rows are inserted while publishing the data

Document ID : KB000016658
Last Modified Date : 14/02/2018
Show Technical Document Details
Question:

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?

Answer:

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.