I’m currently facing an issue with a SQL query that I’m using to export information from an Excel spreadsheet into a datatable. The problem is that the query is supposed to generate two columns in the datatable, but when I use it with the “Write Range Workbook” activity, it only generates the column headers for both columns and leaves the extracted information for only one column but not the second one. I’m looking for assistance on how to make it fill out the second column as well.
I’m confident that the SQL query is correct because I previously used it in Automation Anywhere, where I performed a database read action and successfully exported the results to a .csv file. In that case, I didn’t need a secondary action; everything was seamlessly integrated into a single action within AA using the Database Read From action.
Any help or suggestions on how to resolve this issue with the “Write Range Workbook” activity would be greatly appreciated!