Where to define the primary key while updating data into a database table?
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
abdullah_noor23
7 - Meteor
‎04-06-2023
04:06 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I have a workflow, that appends some record and updates some record in a database table. The append output works, but for the update option I am getting an error. See attachment.
Can anyone please help me with this? Where and how can I define primary key for this workflow?
Labels:
- Labels:
- Best Practices
- Developer
- Output
- Workflow
3 REPLIES 3
Alteryx
‎04-06-2023
11:14 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
19 - Altair
‎04-07-2023
05:25 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @ArtApa
When did the Key for Update option get added? It's not on the File Format Options help page.
Dan
Alteryx
‎04-07-2023
02:07 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@danilang - Options are slightly different for different data sources. It depends on what a data source supports. Flat files don't have keys.
![](/skins/images/33644471E927638F516C93A75ADDEE18/responsive_peak/images/icon_anonymous_message.png)