This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Hi @Sam7, perhaps you can use the option listed at the bottom of the Output data window - Take File/Table name from field. Somewhere in your workflow you can generate the name, and then you can use the option to change the table name, or even use the fully qualified name including directory - here's a good article on this topic -
I use the blob tool to create copies of templates to different file names and locations before outputting to them. This makes sure the template never gets corrupted or changes and takes care of the file name.
As far as putting out to a specific cell, Alteryx has never handled this to my satisfaction. You can see here that there is an acknowledged bug when trying to do this. What I like to do is output Alteryx data to its own tab and then use formulas/pivots on the formatted tabs. It's not a ideal setup, but quicker and better than other solutions I've found. I don't suggest using the reporting tools for Excel because page widths and cell sizes can truncate data if Alteryx calculates there is too much text to fit in a cell.
Alteryx shows outputting to Tableau or other reporting software in their advertising and there is a reason for this.