How do I pull all excel files in a particular folder into a dataset?
Brand new Domo user here, so I apologize if this question is pretty basic.
We have ~300+ clients upload an excel file each week using out Citix Sharefile file drop folder, which we then route into a folder based on which client it came from. We'd like to set up a dataset that pulls in all files in a particular folder regardless of name (there is a common string in each name that we could use). Additionally, due to HIPAA requirements we need to encrypt the data as its pulled in.
Right now the plan is to use workbench's SFTP connection and write separate Powershell scripting to rename each file as it is uploaded so that the most recent will always be named "Current" (or some similar name) - however I know there is a FTP Box connection that can pull files in based on a keyword so hopefully we can build something similar.
Edits: Added information and changed our datasource