我需要在此处进行确切的操作:导入数据后所有列的所有错误值(同时保留行)。
我不知道的是如何将此代码集成到电源查询中的现有代码中。目前,我有下面的代码,生产一个示例文件,然后将其应用于来自文件夹的许多文件。我需要在"启动#"促进标题"之后以及"在"行之前,如已经指示的,不确定如何?我会感谢一些专家建议!
let
Source = Excel.Workbook(#"Sample File Parameter1", null, true),
#"Filtered Rows" = Table.SelectRows(Source, each ([Hidden] = false)),
#"Master doc_Sheet" = #"Filtered Rows"{[Item="Master doc",Kind="Sheet"]}[Data],
#"Removed Top Rows" = Table.Skip(#"Master doc_Sheet",1),
#"Promoted Headers" = Table.PromoteHeaders(#"Removed Top Rows", [PromoteAllScalars=true])
in #"Promoted Headers"
,因此您想在提升标题后替换所有错误:
let
Source = Excel.Workbook(#"Sample File Parameter1", null, true),
#"Filtered Rows" = Table.SelectRows(Source, each ([Hidden] = false)),
#"Master doc_Sheet" = #"Filtered Rows"{[Item="Master doc",Kind="Sheet"]}[Data],
#"Removed Top Rows" = Table.Skip(#"Master doc_Sheet",1),
#"Promoted Headers" = Table.PromoteHeaders(#"Removed Top Rows", [PromoteAllScalars=true]),
#"Replaced Errors" = Table.ReplaceErrorValues(#"Promoted Headers", List.Transform(Table.ColumnNames(#"Promoted Headers"), each {_, null}))
in
#"Replaced Errors"