How can I write to the master database without adding unwanted duplicates? thanks
Solved
I have an existing master database with multiple tables. I would like to append some new records to one of the tables within the master database. I can easily read both tables and write to the existing master database but this results in many dupl
+15- Contributor
Best answer by siennaatsafe
I just got off a Live Chat with @masonb12 so I thought I'd update this if anyone else has the same question.
In his case, he did not need to read in his master table. He could simply write a new table and insert the records from his other tables into the master.
If you did need to update the tables and read in the master you could look into a change detection workflow https://community.safe.com/s/article/change-detection-2
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
+12- Safer
- Best Answer
I just got off a Live Chat with @masonb12 so I thought I'd update this if anyone else has the same question.
In his case, he did not need to read in his master table. He could simply write a new table and insert the records from his other tables into the master.
If you did need to update the tables and read in the master you could look into a change detection workflow https://community.safe.com/s/article/change-detection-2
Login to the community
No account yet? Create an account
An FME Account is required to contribute
LoginEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.