rowid in sqlite writers

Hi @checcosisani, thank you for your question! Sounds like you could benefit from the AttributeManager transformer to update the column to match rowid to the values present in Id: https://docs.safe.com/fme/html/FME-Form-Documentation/FME-Transformers/Transformers/attributemanager.htm

** Untested **

According to the SQLite documentation "Rowid values may be modified using an UPDATE statement in the same way as any other column value can".

In your SQLite writer you can add SQL code to run after the writing has finished, in "SQL to Run After Write” (under “Advanced"). Here you can enter the SQL code needed to give each rowid field the value of your column Id, something like

Update YOUR_TABLE_NAME_HERE set rowid = Id