Power Query: Folder: Multiple Excel Files : Extract creation date

[Anonymous]

Hello,

I am using Power Query Folder option as the data source which will have multiple excel files. All the excel files will be in same format with same header. I need to append all these records with a extra column "Creation Date" and add to the records.

I am almost there but not sure how to merge date created column above with each file.

Thanks,

Karthik

[mahoneypat · Accepted solution]

You can click on the double arrows on the Content column and use the Combine & Transform feature.  Or you can add a column with Excel.Workbook([Content]) to get a Table with the Excel contents, and then update that expression to drill in further.  For example, Excel.Workbook([Content]){0}[Data].

Pat

[Anonymous]

Hello @v-xulin-mstf  / @mahoneypat ,

Both the solution works and thanks for the information. 

For anyone who is referring in future can click below link for more information.

https://anvari.net/Computers_Business/Highline%20Excel%202016%20Class%2021%20PQ%20to%20Import%20Mult...

Thanks,

Karthik

[v-xulin-mstf · Accepted solution]

Hi @Anonymous,

Click combine files:

Expand the table:

If you still have some question, please don't hesitate to let me known.‌‌

Best Regards,

Link

Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!

[mahoneypat · Accepted solution]

You can click on the double arrows on the Content column and use the Combine & Transform feature.  Or you can add a column with Excel.Workbook([Content]) to get a Table with the Excel contents, and then update that expression to drill in further.  For example, Excel.Workbook([Content]){0}[Data].

Pat