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
How do you have your writer setup?
How do you have your writer setup?
See Screen shot.
See 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.