Add Specific Fields from feature class to feature class ArcGIS Desktop tool

[AlexP_]

Hello,

I have SDE, ArcGIS Pro 2.7.1 and ArcMap 10.7.1 along with python 2.7 and 3x and model builder.

I am a bit lost. I tried to look up here but it is all over the places by piece to piece. I am trying to create tools with specific two fields adding new information into from existing SDE feature class to SDE existing feature class. To avoid duplicate and to avoid delete the whole data (to keep what it is already added). I found an append tool to use field matching type: "use the field map to reconcile field differences" and use field map output fields to two fields. At the end, this would need to be automatic weekly. That is all I can find so far with one tool append. I feel like I am missing something. It would be helpful to provide step by step or point it out. I hope this makes sense. Please kindly assist. Thank you.

EDIT:

What tools should I use to avoid duplicate information after using append tool? 

Alex

[AlexP_]

What tools should I use to avoid duplicate information after using append tool? 

[DavidPike]

I'm sorry your post makes no sense to me.

[AlexP_]

What tools should I use to avoid duplicate information after using append tool? 

[DanPatterson]

duplicate shapes? attributes? both?

Delete Identical (Data Management)—ArcGIS Pro | Documentation

[AlexP_]

Thank you for the information. Either shapes or attributes. After reading the document, it is look like field only. Not sure if I am understanding. For example below, can it delete row by using two specific fields? 

[DanPatterson]

Experiment with

Find Identical (Data Management)—ArcGIS Pro | Documentation

limit your fields to what you call "identical" before you commit to any deletion.

And when you want to commit to "delete identical" do it on a copy first since the process isn't reversible.

[AlexP_]

Yes, thank you. I tested it and this is piece what I am looking for.

[AlexP_]

I just noticed that I actually have TWO feature classes to ONE feature class. Is this possible? Is this gonna be an issue when I append and delete identical?  such as to do this weekly. 

[AlexP_]

@DanPatterson @MichaelVolz  When I tried to append tool from sde feature class to sde feature class (view), it failed and gave an error. Am I missing something?

[MichaelVolz]

Can you not do a weekly truncate (delete all existing features) and append of the entire SDE feature class and not worry about duplicate creation by appending to an existing SDE feature class?