I have an automation script that does a data extract and then emails the resulting files. Since I dpn't not want to retain the files, I want to delete these files also. However, when I add a 'Delete' activity, I do not see in the 'Collections' window the files that were created. I expect to see the same as what is in the email activity i.e. the result files already populated for 'adding'
WORKAROUND
Click 'Add' and select the specific file using the browse mode. Repeat for each file to be deleted. **
STATUS
Enhancement request ST91851 has been submitted to Development for consideration in a future release of Toad for Data Analysts.
** If you want to delete multiple files using the same extension e.g. *.xslx do not manually type this in the file dialog box.
Press Add File(s) button under the file list control. Standard Windows Open File dialog will be displayed where the desired file name mask can be submitted for the File name (e.g., '*.xlsx'). After pressing Enter only files complying with this mask will be displayed in the dialog. Pressing Ctrl+A will select all the files in the list and finally pressing Open will place all selected (i.e. all *.xlsx) files into 'Files to delete' list of the Delete File activity input control.
