Forum Discussion
Dataflow and Delta Tables - strange behaviour
Replace = basically deletes all the records in the table and replaces the content in the table with new one
Append = Simply adds new records to an existing table
A method such as "UPDATE AND INSERT" would probably update existing records if it finds any and will try to also insert new ones if they dont already exist. This method doesn't exist today, but you can create a new idea on aka.ms/FabricIdeas for it.
Replace = basically deletes all the records in the table and replaces the content in the table with new one
Append = Simply adds new records to an existing table
A method such as "UPDATE AND INSERT" would probably update existing records if it finds any and will try to also insert new ones if they dont already exist. This method doesn't exist today, but you can create a new idea on aka.ms/FabricIdeas for it.
