Combined cvs's file name column

[hatstand]

Hi All,

I've only recently moved into using Power Query, oh what a change. I am trying include a 'File Name' column after pressing the 'Content' & 2 small arrows icon, which gives me:
let
Source = Folder.Files(C\\MyDocs\CSVs"),
#"Combined Binaries" = Binary.Combine(Source[Content]),
#"Imported CSV" = Csv.Document(#"Combined Binaries",[Delimiter=",",Encoding=1252]),
#"Changed Type" = Table.TransformColumnTypes(#"Imported CSV",{{"Column1", type date}, {"Column2", type text}, {"Column3", type text}, {"Column4", type text}, {"Column5", type number}, {"Column6", type text}})
in
#"Changed Type"

I've tried and tried to follow the guides but as yet nothing has worked. Not that they aren't wrong, I'm obviously doing something wrong. Any pointers or tips would be much appreciated.

 

[sandy666]

I'm moving away form VBA based tools

Welcome to my World

more about PowerQuery aka Get&Transform

• What is PowerQuery
• Getting started with PQ
• PowerQuery Help
• PowerQuery M reference
• PowerQuery add-in for XL 2010/2013, all above has PQ built-in
• General: Excel Help