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.
I have a process where Oracle BI sends me an email each Monday with a Trial Balance with the name "PMM-YY EBS Trial Balance MM-DD-YYYY", but the PMDY are static and do not adjust to the period or month/date/year the data is for. I have setup an Outlook rule to save this file to a desired location and want to use the first part of my Alteryx workflow to rename this file based on the Period Data in Column A and the "Data as of:" date in Cell C2 (see below for how Sheet1 of the TB file looks). In the below example, I'm trying to get the file to be re-saved as "P06-19 EBS Trial Balance 07-15-2019" in the same network folder location as Outlook automatically saves the file to.
I think I have everything perfectly put together except for when it comes to the Output Data tool. The tool seems to be saving the file with the correct period/date name that I want, but it is being saved to the same network folder as where my workflow is based/running and not to the location I specify at the top of the Output Data tool. I am using the "Change Entire File Path" option to achieve this result. When I switch to the Change File/Table Name option, it saves to my desired network location, but the file name gets stuck as "file.xlsx". I'm assuming I'm not using the correct combination of the "Write to File or Database" network location and the "Change Entire File Path" field.
"Write to File or Database" specified in Output Tool: