I have an sftp folder where xml files are getting dropped multiple times a day, sometimes with the same timestamp. Is there a way to add all of the files in that folder to a dataset?
I tried keeping the file path open ended, ending with the folder.
sftp://IP/FOLDER/FOLDER/
I think this method works with CSV Advanced. Is there a way to do this with XML Advance or any other suggestions on how to execute this?