how to rename template file and add week number s

[mingjueca]

Hi, 

here is the background : 

I need to pull weekly data from oracle database and export to excel template file and rename the output file+ fiscal week number. 

for example : Excel template name : ABC_.xlsx  rename to : ABC_W01.xlsx

fiscal week number is from another table in oracle database. 

Originally this report was generated by Access DB, but I would like to use Alteryx instead of Access DB.

Thanks

[AkimasaKajitani]

Hi @mingjueca ,

In this case, firstly you need to copy template file to new path that you want to rename by using Run Command tool.

After that, you save the file to copied template files by Output Data tools by using "Overwrite Sheet or Range", "Preserve Formatting on Overwrite" and "Take/File Table Name From Field" options.

The sample workflow is as follows.

Please check the attached sample workflow. 

If you have any question, let me know.

[mingjueca]

@AkimasaKajitani,  I will try it today.  Thanks. One difference is the FW week is from Oracle database table not from excel file. I will modify your workflow first. Thanks again.