topic Check if file existed and delete in QlikView

Check if file existed and delete

reshmakala — Thu, 17 Nov 2016 16:03:38 GMT

Hello All,

I have a requirement to store the table contents into csv files if they have data. Everyday the file gets overwritten.\

Table:

LOAD * Resident Temp;

if NoOfRows('Table')>0 then

STORE Table into Table.csv(txt);

end if

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?

Re: Check if file existed and delete

marcus_sommer — Thu, 17 Nov 2016 16:16:09 GMT

You could include the following in your logic:

if filesize('Table.csv') > 0 then

EXECUTE cmd.exe /C del Table.csv;

end if

- Marcus

Re: Check if file existed and delete

reshmakala — Thu, 17 Nov 2016 16:28:33 GMT

Thank you!