Good day! can someone assist on how can I use a latest excel file I have saved as my input file without going through connecting to a file. for context, the solution worked for me below but it is only giving me a dataset with file names and which one's recent. thanks!
@MickeyL As mentioned in the above post you need to use the directory tool and sort based on the creation date, if you want to read the file use the dynamic input tool or bath macro
@MickeyL Attaching a sample workflow
User | Count |
---|---|
109 | |
89 | |
77 | |
54 | |
40 |