我尝试通过复制和粘贴查询将工作表从一个工作簿复制到另一个工作簿。这些查询在原始工作表中运行良好,但当我复制它们时,出现错误
Expression.Error: The Argument Name isn't Valid. Details: List
正在进行的查询是:
let
Source = #"Base Table",
#"Replaced Value" = Table.ReplaceValue(Source,null,0,Replacer.ReplaceValue,List.Select(Table.ColumnNames(Source), each Value.Is(Value.FromText(_), type date))),
#"Unpivoted Other Columns" = Table.UnpivotOtherColumns(#"Replaced Value", List.Select(Table.ColumnNames(#"Replaced Value"), each not Value.Is(Value.FromText(_), type date)), "Date", "Value"),
#"Changed Type" = Table.TransformColumnTypes(#"Unpivoted Other Columns",{{"Date", type date}, {"Value", type number}}),
#"Filtered Rows1" = Table.SelectRows(#"Changed Type", each [Value] <> 0),
#"Added Custom" = Table.AddColumn(#"Filtered Rows1", "Custom", each [Value] * [Billable Rate]),
#"Renamed Columns" = Table.RenameColumns(#"Added Custom",{{"Custom", "Monetary Value"}}),
#"Removed Other Columns" = Table.SelectColumns(#"Renamed Columns",{"Group", "Region", "Level", "Name", "Client", "Mandate", "Mandate Code", "Billable? (Y/N) ", "Status", "Recovery", "Billable Rate", "Date", "Value", "Monetary Value"}),
#"Appended Query" = Table.Combine({#"Removed Other Columns", dates})
in
#"Appended Query"
在复制的工作簿中,该工作表称为 Sheet 8,而在另一个工作簿中,该工作表称为 Period Totals。在新工作簿中,还有其他几个查询与外部数据库有连接,但在原始工作簿中却没有 - 这可能是个问题吗?
关于如何调试/解决此问题,您有什么想法吗?不确定是什么原因造成的 - 这是 excel 错误吗?谢谢!!
答案1
我将从查询编辑器窗口的查询窗格中复制查询对象。该方法更可靠,因为它包括任何依赖对象。