Oracle Upsert (insert / update)
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I am trying to use alteryx to replace a different ETL tool and I am wondering if it is possible to use the Write Data In-DB tool to do an Upsert or an insert and/or update. With the output data tool there is an option for update; insert if new. Is there an options for this with any of the In DB tools?
Solved! Go to Solution.
- Labels:
- In Database
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I don't believe that there is an option to 'Upsert' with the In Database tools. Your best option is to use the Data Stream Out to pull the data out of the In Database stream and then use a normal output tool to perform your 'Upsert'.
Regards,
Taylor
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks Coxta45! You answered my follow up with the stream out tool!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Glad to help!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I miss this feature too... still using Pentaho fro Upserts...be good to see this as a feature in the tool.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello,
This would make a great idea for our product ideas page. If anyone would like to post it please visit http://community.alteryx.com/t5/Alteryx-Product-Ideas/idb-p/product-ideas.
Thanks!
Manager, Technical Account Management | Alteryx
