我有一个带有数据表的excel工作簿(book1)。
在另一本工作簿(book2)中,我有一个使用此数据作为源的超级查询。想法是轻松地在book2中获得book1中表的本地只读副本。
当在源中添加其他列时,我不太清楚如何更新查询。我没有尝试将新列拉入查询。我很困惑,因为查看M代码似乎只是引用book1中的整个表:
let
Source = Excel.Workbook(File.Contents("M:\!OtherStuff\!Cellar CIP Logs\CIP Lab 2020\CIP Storage.xlsm"),null,true),eqm_Table = Source{[Item="eqm",Kind="Table"]}[Data],#"Changed Type" = Table.TransformColumnTypes(eqm_Table,{{"Equipment",type text},{"Category",{"Group",{"CIP Types",{"Data Type",Int64.Type},{"Sani Duration (hrs)",{"Interval Duration (hrs)",{"Linked Status",{"Class",{"Status",{"Last action",type datetime},{"Status History",{"Last action History",{"Interval Last action",{"Empty",type any},{"1 Validation",{"1 CIP Types",{"1 Value",{"2 Validation",{"2 CIP Types",{"2 Value",{"3 Validation",{"3 CIP Types",{"3 Value",{"4 Validation",{"4 CIP Types",{"4 Value",{"5 Validation",{"5 CIP Types",{"5 Value",{"6 Validation",{"6 CIP Types",{"6 Value",{"7 Validation",{"7 CIP Types",{"7 Value",type text}})
in
#"Changed Type"
因此,假设我在源表的“空”列之后添加了“空历史”列。要使book2中的能力查询在刷新新列时需要采取什么步骤?