Forum Discussion
Solved
Excel File Name in a Custom Column
Hello, I have a report that pulls data from multiple excel files from a folder. The excel file names have data that we'd like to use in the report. Just wondering how to do that using a custom colum...
Hey in this case, you can choose Get data > Folder, once you choose folder, you will see all excel files name in your PQ. then you can do some data cleaning process to shape the data as the format you want in the report. Hope it is helpful!
Hey in this case, you can choose Get data > Folder, once you choose folder, you will see all excel files name in your PQ. then you can do some data cleaning process to shape the data as the format you want in the report. Hope it is helpful!
Thanks! I found it under the Source.Names column when I combined the files after loading 🙂
