# Export dataset multiple queries

**URL:** <https://forums.toadworld.com/t/export-dataset-multiple-queries/43443>\
**Category:** Toad for Oracle & DevOps Toolkit\
**Created:** [November 6, 2018, 5:47pm UTC](https://forums.toadworld.com/t/export-dataset-multiple-queries/43443 "2018-11-06T17:47:49Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\
**Post date:** [November 6, 2018, 11:08pm UTC](https://forums.toadworld.com/t/export-dataset-multiple-queries/43443/2 "2018-11-06T23:08:51Z")

</div>

The Folder Iterator is what you want here, but I see that the export dataset's "SQL FIle" feature doesn't support variables. I am adding this for next beta. Assuming all your SQL files are in the same folder, you will be able to do this:

.SQL Files are in a folder called c:\Queries.

Set up your action like this:  
 ![image](https://global.discourse-cdn.com/quest/original/2X/8/881d992440fd72b68b64fb0e2d329264e1365260.jpeg)

Folder iterator detail:  
 ![image](https://global.discourse-cdn.com/quest/original/2X/6/63759a9ad07582121029a105cd962648bec05a51.jpeg)

Export Dataset detail:

 ![image](https://global.discourse-cdn.com/quest/original/2X/5/5f8eab4c07b6afab687037193f74ef3a81554340.jpeg)

 ![image](https://global.discourse-cdn.com/quest/original/2X/e/ea01efdad76f926949c06b1c15d32d3e886d1f89.jpeg)

then, right-click on the "Folder" action and choose "Run".

---

_[View the full topic](https://forums.toadworld.com/t/export-dataset-multiple-queries/43443)._