Output data if there is one if blank then output headers

[aparna0208]

Hi,

I have a workflow that outputs multiple tabs into an excel. There is one particular tab where sometimes you won't have any data and sometimes there is data. Wanted to see if there is a way to write the data if there is one and if it's blank then just output the headers.

Example:

If the workflow output contains data then

Branch       Customer ID           Segment

BR123        23244                      NU

If workflow output contains no data then

Branch        Customer ID             Segment

[atcodedog05 · Accepted solution]

Hi @aparna0208 

test the above 2 approaches for your requirement they should work. Test it with data and no data. If they don't work let me know what issue you are facing.

Approach -1

Approach: If you want to write to multiple tab with a single output tool

Hope this helps : )

[aparna0208]

I tried the first approach and it worked:) Thank you for patiently answering all my questions! @atcodedog05 

[atcodedog05]

Happy to help : )  @aparna0208 

Cheers and have a nice day!

[Bob_Loblaw]

Hi, your solution works but I only have one question

I am adding a field which is the name of the file so my output can add this field to the name. However, using your workflow I am not getting any values for this field and all returns as Null. Any ideas how I can keep this field only to produce the desire result while using the rest of your workflow?

Essentially I want the workflow to still generate the output excel file even if fields return as null and rename the file as one of the fields I have added as a formula.