Return
-
Title
Automation script not writing to second tab in an Excel file -
Description
Automation is set up to perform the following steps:1. Copy a blank excel template to a specific file name with data suffix (copy file action).2. Execute a SQL query and write to a specific tab in the Excel file (select to file action)3. Execute a second SQL query and write to another tab in the same Excel file (select to file action)Everything works except for the last step – although the query brings back data, there is nothing on the second tab when the query finishes.
Sign In Required
You need to be signed in and under a current maintenance contract to view premium knowledge articles.