I have just started using Toad DataPoint for automation. The process I am trying to automate requires a file to be uploaded to database.
Is there a way to check if file is available?
Is it possible to do a pre-validation on the file, or something similar?
The last file I processed had comma delimited text in one cell. Although the .csv had it enclosed in quotes, the script failed the row as it considered the data for multiple columns instead of one.