M语言简单示例--加载多个相同格式的文件到一个文件中

1.先打开文件夹中的其中一个文件

2.启动编辑器，做相应的基础转换操作

3.点击-视图，点击-高级编辑器

4.添加函数，修改函数中的路径和文件名，即高亮部分

let

    源 = Excel.Workbook(File.Contents(" C:\Users\DengXiaoju\Desktop\Sample Files\Chapter 12\test\WEST.XLS "), null, true),

    MySheet1 = 源{[Name="MySheet"]}[Data],

    提升的标题 = Table.PromoteHeaders(MySheet1, [PromoteAllScalars=true]),

    更改的类型 = Table.TransformColumnTypes(提升的标题,{{"Region", type text}, {"Market", type text}, {"Branch_Number", Int64.Type}, {"Customer_Name", type text}, {"State", type text}, {"Effective_Date", type text}, {"Product_Description", type text}, {"Revenue", type number}, {"TransactionCount", Int64.Type}}),

    删除的列 = Table.RemoveColumns(更改的类型,{"Branch_Number"})

in

    删除的列

5.修改函数

let GetMyFiles=(FilePath, FileName) =>

let

    源 = Excel.Workbook(File.Contents("C:\Users\DengXiaoju\Desktop\Sample Files\Chapter 12\test\WEST.XLS"), null, true),

    MySheet1 = 源{[Name="MySheet"]}[Data],

    提升的标题 = Table.PromoteHeaders(MySheet1, [PromoteAllScalars=true]),

    更改的类型 = Table.TransformColumnTypes(提升的标题,{{"Region", type text}, {"Market", type text}, {"Branch_Number", Int64.Type}, {"Customer_Name", type text}, {"State", type text}, {"Effective_Date", type text}, {"Product_Description", type text}, {"Revenue", type number}, {"TransactionCount", Int64.Type}}),

    删除的列 = Table.RemoveColumns(更改的类型,{"Branch_Number"})

in

    删除的列

in  GetMyFiles

6.-查询设置位置重命名函数为fnGetMyFiles1

7.-添加列-自定义列，输入函数

= fnGetMyFiles1( [Folder Path], [Name] )

8.展开列