Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Outputting only headers in Excel file or no files: why does this happen?

AT_1988
5 - Atom

HI, I am wondering why the following difference occurs in Alteryx Designer.

 

When I want to output Excel files and

(1)there is no data with the default output tool option, the output is only headers in Excel files.

(2)there is no data and use the option "Take File/Table Name From Field" with "Append Suffix to File/Table Name", no Excel file outputs.

 

I suppose Alteryx Designer uses the file path writtien on "Write to File or Database" in Output tool configuration window as default.

 

When I use the option "Change File/Table Name" and the reffered field has NULL data, error occurs  -  I understand that because no sheet name will be set with the file path.

 

But, when I set the option "Append Suffix to File/Table Name" and the reffered field has NULL data, I expected Alteryx outputs only heders like (1) above because there is still file path with sheet name in the configuration window.

2 REPLIES 2
Raj
16 - Nebula

@AT_1988 
please add some sample input and expected output will help with the flow.

AT_1988
5 - Atom

thank you for your reply,I just made sample workflow.

Labels