Hello,
I am running a workflow where it extracts data from SAP HANA Studio and output csv files weekly. The filename is based on the week and year.
However, if I run the workflow twice in the same day it output the same week file twice.
Is there a way to check if the csv is already in the folder then either skip that week or overwrite.
Any help would be greatly appreciated.
Thank you
Regards,
Pankhudri Agrawal
Hello @Pankhudri20 ,
You could use this:
With a formula to look for the file name:
If it exists will return true, else false.
Then filter. If it's false, write the output. If not, send a message.
Gabriel
Hi @Pankhudri20
You can't write a file to a directory with exactly the same name twice. If the file already exists, the new version will overwrite the existing file if existing file isn't locked. If it is locked, you'll get an error.
If you're getting two files written to the same subdirectory, they must have different names. Possibly the time is included in the filename. Can you show us a screen shot of a case where the file is written more than once.
Dan