We are on FME Desktop 2021.2.2
Currently have a FeatureWriter that can insert new records (Account ID with their correspondence amounts) into SQL table from a source CSV file. See below:
For each import, the CSV file could have same Account ID with different amounts. Therefore, we'd need to truncate any existing matching Account IDs rows and replace with new data. Changed Table Handling to 'Truncate Existing' but the amount still doesn't change.
Heard you can change Feature Operation to 'upsert' but don't have that option
Thanks.
Best answer by dustin
View original