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.
Hi,
I'm not sure exactly what you mean about "Replace method".
The sink activity has the option to make trucate or append in relation to the existing table.
In relation to the operations record by record, there is the option to enable update, insert and upsert.
But I'm not much sure which option you mean when you mention replace. Could you show a screenshot?
By the way, if the sink activity is set to truncate the table before the operations, it will always reflect the excel file
Kind Regards,
Dennes