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 that I am trying to transition to Alteryx.
The process begins with running a stored procedure which then writes the data into excel spreadsheet (sheet 1)
The excel has some pivot tables in other tabs(sheet 2). Currently the excel file is connected to a backend database. As soon as the data is refreshed in the table, Sheet 1 and pivots(Sheet 2) all get updated.
The requirement is that this process be run on a daily frequency and the pivot automatically gets refreshed for THAT DAY only when the raw data is loaded(sheet 1). Each day will be its own separate file. What I don't want is today's data to update historical versions of the file when opened. How can i move this process to Alteryx?
What I would recommend is making use of a 'template file'. This template would have the structure of the pivots and the data tab for alteryx to output into. You would want to make sure the output tool is configured to append to that data sheet rather than overwrite it in order for your pivots to still work.
From there, you would make use of the run command tools to do the following when the workflow is ran each day:
Make a copy of the template file
Output the data
Rename the file with todays date (or whatever naming convention you use)
I have an example of this in this thread you could reference:
Thanks @Luke_C for the solution. This may resolve the issue
I am new to using run command. I imported your solution and replicated this process using my set of files. Here is the Error message I got - "The external program "%temp%\Rename.bat" returned an error code 1".
I have a quick question. It seems like both the Copy.bat and Rename.bat are running from the default temp folder. Perhaps it is failing because the filenames may need to be changed within the .bat files. I am not able to locate these files in my temp or any user folders.. Could you share the code used within the Copy and Rename.bat files please?