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.
@AT_1988
please add some sample input and expected output will help with the flow.