I have a requirement to store the table contents into csv files if they have data. Everyday the file gets overwritten.\
LOAD * Resident Temp;
if NoOfRows('Table')>0 then
STORE Table into Table.csv(txt);
If there is data in the table today, the file gets created but what if I do not have data tomorrow. The file would still be there in the folder. Is there anything I can do to check if file existed and delete before creating a new one?