Power query question

[neobaron]

Hello Everyone,

i have one power query in reference to a folder. In the folder there are several documents (CSV) and i expand them but i need the creation date of the document. When i make the reference (they are already expanded) multiply the rows per the number of documents that was in the previous folder giving each one the date of each document. Did you find any solution for that?

Thank you in advance for your help!

 

[Useful]

Hi!
after providing the folder path - instead of expand try to use add custom column and Csv.Document() to extract data. And then use Table.PromoteHeaders() to order your tables. And after all you may to use expand.