How to not create output when no records

[olivia_paquot]

Hi !

I have a workflow with several outputs, and several of these outputs can be empty (no records).

How I can stop the output(s) where I have no record, and allowing at the same time the creation of the other outputs where there is at least one record ?

Thanks a lot !

Kind regards,

Olivia

[rpenatez_dup_538]

Hi Robin,

You need to use a Formula tool to create new fields 😉

[arvindhbhujang]

Excellent solution.

Thanks a lot. Its worked for me.

[DataBob]

Mark, Thanks for a simple solution that works!  Do you happen to know why it works?  Do formulas not return a result when the input is empty?

[ngarrepa]

Hi 

will this work even if i write to an sql table? 

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.

Appreciate your help.

nik

[ak2018]

add a formula field before the output. That worked for me.

[ngarrepa]

@ak2018 

What kind of formula?

[ak2018]

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. 

[NaomiMariaThomson]

Hi Robin,

The field can be created using a Formula tool or a Multi row formula tool and it can be added right at the end before the final output.

Regards,

Naomi