Skip to main content

I see the file geodatabase writer has pre and post writer SQL options. So I assume I can do some deletion before inserting. Can I do "delete from table where attribute = 'attributeValue'"? Not sure what the syntax should be.

 

A better approach would be to use a FeatureWriter to delete these features before they get written. You can add a WHERE Clause to filter out those you want to removeScreenshot 2020-12-16 080725


The problem is that the pre and post SQL does not have any notion of feature attributes, so you cannot reference any feature attributes in the SQL. However, you can reference private or public parameters.

If you need to delete based on a feature attribute, there is the DatabaseDeleter transformer, or you can look into the suggestion from @hkingsbury​ 


@hkingsbury and @david_r, thanks for the advice. I will try use where clause. Basically delete existing records before inserting new ones. Use this for RDBM like Oracle all the time, never used against a file geodatabase.

 


Reply