Data360 Analyze: How to bypass a node with zero records

Ordinarily, nodes in a data flow depend on data from another node in order to run and return more data, and when that value is zero, the graph fails. This article outlines how to make a data flow continue even if no data has been passed through one of the nodes, in this example, the DB Execute node.

RESOLUTION:

The simplest way to deal with this is create a Static Data node that contains a value that is impossible to be returned by the query, such as all zeroes, etc.

Concatenate that into the data stream going into the DB Execute.This way, the second query will always have at least one record.