I have a bot that reads excel file from a dump directory. I'd like to know if how I can retrieve the filename of a file and save it to a variable so that when I write the result file the original file name would be there.
Sample:
Original File name: CompanyABC.xslx
Output File: CompanyABC-Processed-2019-9-11.xslx
Sample:
Original File name: CompanyABC.xslx
Output File: CompanyABC-Processed-2019-9-11.xslx