Power query and loading a column into multiple files in a folder before importing them from the folder

[seancsn]

I have 36 large csv files (each around 3GB in size) that I have a in a folder on my c drive. I would like to use the folder import option in Power Query. Before they are imported, I need to add a column eg. Monthdate, which inserts a date into all rows for a file, which is specific to the name of the file eg. if the file is named "Jan 15" then I need the date to be inserted to be "15/01/2015" etc.

Would this be possible or should I import each file individually and add the column manually?

Thanks in advance

Sean

 

[RudiS]

Hi Sean,

You can import the csv files with a custom formula instead of the Binary expansion. If this question is still valid, I can help you out with this query. Its quite an easy process using Power Query.

 

[seancsn]

Thank you so much RudiS. I have managed to deal with it through Power Query and method described by Ken Puls

 

[RudiS]

Excellent. I thought I'd just inquired since there was no replies to the post. Cheers.