# Export Dataset Data Substituion Specific to Table

**URL:** <https://forums.toadworld.com/t/export-dataset-data-substituion-specific-to-table/37246>\
**Category:** Toad for Oracle & DevOps Toolkit\
**Created:** [April 13, 2016, 5:59am UTC](https://forums.toadworld.com/t/export-dataset-data-substituion-specific-to-table/37246 "2016-04-13T05:59:21Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![deggen](https://avatars.discourse-cdn.com/v4/letter/d/c89c15/32.png) [@deggen](https://forums.toadworld.com/u/deggen)\
**Post date:** [April 13, 2016, 5:59am UTC](https://forums.toadworld.com/t/export-dataset-data-substituion-specific-to-table/37246/1 "2016-04-13T05:59:21Z")

</div>

Would it be possible to set a data substituion value so that it only applies to a specific table when creating an insert script?

---

<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:** [April 13, 2016, 8:25am UTC](https://forums.toadworld.com/t/export-dataset-data-substituion-specific-to-table/37246/2 "2016-04-13T08:25:49Z")

</div>

Oh yeah, I see how that could get confusing. OK, next beta, field substitutions will be cleared if you export a different table than when the field subs were set up.

---

<div class="post-metadata">

**Author:** ![deggen](https://avatars.discourse-cdn.com/v4/letter/d/c89c15/32.png) [@deggen](https://forums.toadworld.com/u/deggen)\
**Post date:** [April 13, 2016, 9:21am UTC](https://forums.toadworld.com/t/export-dataset-data-substituion-specific-to-table/37246/3 "2016-04-13T09:21:57Z")

</div>

Would it be possible to make certain fields apply to all tables?

---

<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:** [April 13, 2016, 11:45am UTC](https://forums.toadworld.com/t/export-dataset-data-substituion-specific-to-table/37246/4 "2016-04-13T11:45:54Z")

</div>

that’s kinda what it did before your request - for example, if you set up a substitution on SCOTT.DEPT, in the DEPTNO column, then exported, then switched over to SCOTT.EMP, which also has a DEPTNO column, the setting would be there for that table too.

If you are going to be doing repeated exports of the same tables, I’d suggest you set them up in the automation designer. Then you can just kick them off whenever you need to and they’ll keep whatever settings you gave them.
