Hello UiPath Community! I’m looking for suggestions on how to tackle this issue in the most efficient way possible.
I am currently downloading zip files from an FTP site on a daily basis. Every day the file will have a new name. I believe I have an effective workaround for this and my sequence that downloads the files works perfectly.
What I’m unsure of is how to go about reading the csv file in each zip file. There is no way around this, the client provides the data in this format. There could be multiple zip files, but each zip file only has one csv file. Essentially I want to read the file into a data table and then begin the process of working through the data.