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.
With Excel files, "Change File/Table Name" updates the sheet name, not the actual file name itself. Alteryx thinks of excel sheets as "tables".
To output to unique files, you will need to use "Change Entire File Path" - however this will output these files to the directory your Alteryx workflow is in unless we make one more change - adding G:\FTP\sales\Samantha\DataExtracts\out\ to the "FileNameOutput" field.
You could modify your FileNameOutput formula to include this, or add a new formula tool with the following formula:
Based on your brief I have attached a workflow which you should be able to modify to achieve your desired output. I have an image below with annotations in the tool containers and tool notes to describe what you will need to do. The Yellow containers are all you should have to update to get the workflow to work. That said you need to confirm if the unzipping process using the run command tool successfully unzips .gz.
that is correct the output tool will be outside the macro.
As this is an xlsx. output in your filename field before outputting you will need to add a sheet name. In a formaul you can up date the filename field with [filename]+"|||Sheet1". You can of course use another field in your data set to label the sheet or rename it in the formula.
You then need to select the tick box in the bottom left in the configuration window of the output tool in your image below. "Take file/table name from field'
Change the dropdown menu to 'change entire file path' - Here you will then select the filename field in the final dropdown menu. If you want to include this as a field in your dataset don't uncheck the box.
Once you runt his workflow this should generate your files