This is about the lower part of TesterNoType

In table 1 I have ex

 Filename, Type, Date
                       Parks, 1, 2018-01-22
                       Parks, 4, 2018-01-22

Table 2 aka new information table I have information about 1000 parks In table 3 aka old information table I have 988 parks, some have stayed the same and should not be changed, some have old info about the type of the park

I have another workspace where I send the filename as Feature to Read and reads the table and writes to table 2.

In the old one with no types I only wrote the reader from the new and truncated the old and voila, but here I can't truncate, I want to both add all new rows and for every row that has type 1 for example (same obj id can happen in old and new or not).

I only want to replace every single row in table 3 that has type 1 and replace it with the information from table 2 instead. All that not has type 1 should still be there.

I'm doing a very simplified version of this now where I only read Parks, 1 and should read parks table from the old GDB and write to another GDB where I have the old version of Parks, but the writing part where I only want to replace where attribute type=1 doesn't seem to be working.

Should I do a SQL script somewhere or only read rows where type=1 or find another way to do this?

This is about the lower part of TesterNoType

In table 1 I have ex

Filename, Type, Date
Parks,    1,    2018-01-22
Parks,    4,    2018-01-22

Table 2 aka new information table I have information about 1000 parks In table 3 aka old information table I have 988 parks, some have stayed the same and should not be changed, some have old info about the type of the park

I have another workspace where I send the filename as Feature to Read and reads the table and writes to table 2.

In the old one with no types I only wrote the reader from the new and truncated the old and voila, but here I can't truncate, I want to both add all new rows and for every row that has type 1 for example (same obj id can happen in old and new or not).

I only want to replace every single row in table 3 that has type 1 and replace it with the information from table 2 instead. All that not has type 1 should still be there.

I'm doing a very simplified version of this now where I only read Parks, 1 and should read parks table from the old GDB and write to another GDB where I have the old version of Parks, but the writing part where I only want to replace where attribute type=1 doesn't seem to be working.

Should I do a SQL script somewhere or only read rows where type=1 or find another way to do this?

This is about the lower part of "TesterNoType"

In table 1 I have ex "Filename, Type, Date Parks, 1, 2018-01-22 Parks, 4, 2018-01-22"

In Table 2 "aka new information table" I have information about 1000 parks In table 3 "aka old information table" I have 988 parks, some have stayed the same and should not be changed, some have old info about the type of the park

I have another workspace where I send the filename as "Feature to Read" and reads the table 3 adn writes to table 2. In the old one with no types I only wrote the reader from the new and truncated the old and voila, but here I can't truncate, I want to both add all new rows and for every row that has type 1 for example (same obj id can happen in old and new or not).

I only want to replace every single row in table 3 that has typ 1 and replace it with the information from table 2 instead. All that not has typ 1 should still be there.

I'm doing a very simplified version of this now where I only read "Parks, 1" and should read parks table from the old GDB and write to another GDB where I have the old version of Parks, but the writing part where I only want to replace where attribute type=1 doesn't seem to be working, please help. Haven't found a good answer here. Should I do a SQL script somewhere or only read rows where type=1 or find another way to do this?

This is about the lower part of TesterNoType

In table 1 I have ex

 Filename, Type, Date
                       Parks, 1, 2018-01-22
                       Parks, 4, 2018-01-22

Table 2 aka new information table I have information about 1000 parks In table 3 aka old information table I have 988 parks, some have stayed the same and should not be changed, some have old info about the type of the park

I have another workspace where I send the filename as Feature to Read and reads the table and writes to table 2.

In the old one with no types I only wrote the reader from the new and truncated the old and voila, but here I can't truncate, I want to both add all new rows and for every row that has type 1 for example (same obj id can happen in old and new or not).

I only want to replace every single row in table 3 that has type 1 and replace it with the information from table 2 instead. All that not has type 1 should still be there.

I'm doing a very simplified version of this now where I only read Parks, 1 and should read parks table from the old GDB and write to another GDB where I have the old version of Parks, but the writing part where I only want to replace where attribute type=1 doesn't seem to be working. 

Should I do a SQL script somewhere or only read rows where type=1 or find another way to do this?