Outputting only headers in Excel file or no files: why does this happen?
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@AT_1988
please add some sample input and expected output will help with the flow.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
