|
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件 ★ 免费下载 ★ ★ 使用帮助★
- let
- 源 = Table.SelectRows(
- Folder.Files(Text.TrimEnd(Excel.CurrentWorkbook(){[Name="path"]}[Content][Column1]{0},"")),
- each Value.FromText(Text.Start([Name], 1)) is number
- )[Content],
- souce =
- let
- a = List.Transform(源, each Table.RemoveColumns(Excel.Workbook(_){1}[Data], "序号")),
- b = Table.ExpandTableColumn(Table.AddColumn(a{0}, "tb", each a{1}), "tb", {"日期", "时间叠加提成比例"})
- in
- b,
- 已添加索引 = Table.AddIndexColumn(souce, "索引", 1, 1, Int64.Type),
- 重排序的列 = Table.ReorderColumns(已添加索引, {"索引", "赔偿款(万)", "提成比例(%)", "提成额(万)", "日期", "时间叠加提成比例"}),
- 更改的类型 = Table.TransformColumnTypes(
- 重排序的列,
- {{"提成比例(%)", Percentage.Type}, {"日期", type date}, {"时间叠加提成比例", Percentage.Type}}
- )
- in
- 更改的类型
复制代码 |
|