This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I have a workflow with two outputs and writes to same table. If condition is true, work flow will run a pre-sql step and writes data to table A. If condition is false workflow will run a different pre-sql query writes data to same table A. I am trying to prevent running pre-sql query and write to table if one of the conditions has 0 records.
Use the Fomula Tool, create a field and name it NULL. Change the type to String and type NULL() in the formula space. That should do it. And in your Output Tool, indicate to get the "table name" from this field and not to include it in the output.