I am trying to get FME to compare all fields (no key) and only insert uniquid rows.
On initial insert all works great but when I go into excel and change a few field values of a rows or two, FME does not update.
Instead it inserts them as new rows.
How can I overcome this?
Thanks
B
+62See Screen shot.
Assuming you have that writer set to update mode and the ChangeDetector is actually seeing those records as updates, I think you do need to specify a key. Is the xlsx_row_id attribute (I think that's what it's called) available, if not see if you can use an AttributeExposer to make it visible and then use that as a key.
I do suspect that if you insert a new row somewhere between existing ones all the ones after it will be seen as changes too.
