Running SQLite Import Script Removes Overlapping Data Meaning No Changes Take Place

[DanAE111]

Hi,

When running the import script against my SQLite DB it appeared to make no changes i stepped through the SQL script and can see during the process the data it pulls from "elec_feed_in_tariff_1_high_resolution" is removed from the table "temp.STATS_NEW". As the rest of the script runs though the result ends up being no change to the statistics table in the database.

Unsure what I've done wrong here, the entity I'm trying to update is a template sensor. Which I've previously updated with a input number helper.