How to automatically update rows with file name from a dynamic data import?
I'm working on a script that imports multiple files from a folder into a single data table. I have created a column listed USP_ID, in which I would like the filename to appear in each row. Although the data imports correctly, only the name of the final imported excel file is displayed in this column, whereas I would like each file name to be displayed in the rows corresponding to its respective da...