Output data if there is one if blank then output headers

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

Output

Accepted answers

atcodedog05

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 : )

Blank headers multiple sheets.yxmd

blank headers.yxmd

All comments

Emil_Kos

Hi @aparna0208,

Please check my solution.

What I have done is use the count records tool to create at least one line of the text. The workflow should output just headers if that situation will show up.

TEST.yxmd

ArtApa

Hi @aparna0208 - In Alteryx almost everything can be done in a couple of different ways. My approach is to push headers down as the first row of data and configure the output data tool to skip field names. You can Union by position with your data and you will not need to perform any checks.

HeadersAA.yxmd

aparna0208

@Emil_Kos Thanks for your inputs. I tried this but still not getting the expected output(blank headers)

aparna0208

@ArtApa This actually works when I configure output data tool to skip field names. The problem is I have multiple tabs writing to an excel and this is just one tab so I don't think I'll be able to configure the output tool as it would impact other tabs.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703