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.
There are two ways that I can think of off the top, depending on what you want to do. Both take advantage of the "Take File/Table Name From Field" option in the Output Data tool.
One configuration is to put the full path in a field (e.g. FileName) -- like this "C:\Temp\data.mdb|mytbl_09282018". In this case, you can set the "Write to File or Database" parameter of the Output Data tool to a fake path (like c:\temp\out.mdb|out) and use the "Change Entire File Path" method.
The other configuration is to put just your table name in a field -- like "mytbl_09282018". In this case you would need to set the "Write to File or Database" parameter to the actual path and database name you want, but with a fake table name (like c:\temp\mydata.mdb|out). Then you can use the "Change File/Table Name" method.
For completeness, I feel like I should point out that you can use other Alteryx tools, functions and features to your advantage.
Workflow constants - Using %Engine.WorkflowDirectory% will output your data to the folder where the workflow is saved. %Engine.TempFilePath% writes to a workflow-specific temporary path. This can be great because your output would be deleted once the workflow is closed.
Formula tool - Take advantage of the File functions. FileAddPaths() can make things much easier to read and the DateTime functions can give you the current date dynamically.