Hi @MollyMcEvilley , What do you think about moving `truncate table tlsa_Household` before `if (select LSAScope from lsa_Report) <> 3` ? <img width="566" height="289" alt="Image" src="https://github.com/user-attachments/assets/57b032e5-76b0-4b69-b6b9-17bc90764f23" /> Best regards, Natalie
Hi @MollyMcEvilley ,
What do you think about moving

truncate table tlsa_Householdbeforeif (select LSAScope from lsa_Report) <> 3?Best regards,
Natalie