How to update or create an excel file using batch macro

[Lumjing]

Hi I have a column with SQL query and I am using a batch macro (where I have used dynamic input tool to run the sql query. 5 rows of sql query execution. Every time I run the workflow I want a excel file where the output of the all the sql to be update in excel file one after another. Can you please let me know how to achieve this. A sample of the input file is as below.

SQL code

Select Distinct(Name) from table xyz

Select Distinct(Name) from table xyz

Select Distinct(Name) from table xyz

Select Distinct(Name) from table xyz

Select Distinct(Name) from table xyz

[alexnajm]

Whatever unique value you have in a column to separate the 5 queries can be used as your tab name in the Output Data tool - if you don't have one, create one using a RecordID tool or a Multi Row Formula tool!