Skip to main content
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

  • February 11, 2021
  • 1 reply
  • 14 views

masonb12
Contributor
Forum|alt.badge.img+12

How can I write to the master database without adding unwanted duplicates? thanks

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

View original
Did this help you find an answer to your question?

1 reply

siennaatsafe
Safer
Forum|alt.badge.img+10
  • Safer
  • Best Answer
  • February 12, 2021

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


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings