I am working on a project that requires the addition, update, and delete of field using Qlikview as part of an automation initative in my company.
As of right now I have imported an excel extract that contains NEW data based on a primary key called [ID], I have also imported a SQL table with HISTORICAL values, the primary key is [ID] as well. The problem is I am trying to delete values in the SQL Historical Table that match [ID] with New values on the excel extract so I can insert all new values into the historical table without getting duplicates. I have considered update but it is more complex and there are new records occasionally that are in the extract but not in historical that need to be added to historical.
Here is what I have so far...
SQL DELETE [ID]
FROM "DB NAME HERE".dbo."TABLE NAME HERE"
WHERE [TABLE NAME HERE.Known Error ID] IN extract file
In bold is the problem, any suggestions? I had to censor some db information for company sake.