There should be 10 files (can be of .txt/.csv/.xlsx) of the same schema in the directory.
The idea is to consolidate all the data and write it to .csv with the source names. Catch is to pop an error and the workflow should stop executing the files are less than 10. In additon to that user should get a prompt about which file is missing.
Solved! Go to Solution.
Try the attached workflow and file set-up. I've set everything to 'relative', so it should work once unzipped. If not, there are two places where you will need to update the dependency.
In the 'Files' directory that we are testing, there are 10 files. So when first run, they open and get unioned.
If you remove any of the 10 files in that folder, no union happens, and there's a spot that shows the user what file(s) are missing.
I'm sure you'll want to modify as needed, but hopefully this points you in the right direction.
Good luck.
Thanks for the Solution.
One More question is regarding the problem when the file is less than the 10 then none of the data should be uploaded in Database can you helpme with this problem.
Thanks in Advance !!!