☰

Excel：将“仅连接”改回查询

tag-icon • tag-icon microsoft-excel worksheet-function
Excel：将“仅连接”改回查询

在 Excel 中，其他用户更改了我的查询。它从连接到 Excel 选项卡（下图中显示的是并行过程） 创建选项卡的查询

改为“仅连接”，如下图所示： 仅连接。

Power Query 显示：

let
Source = Table.NestedJoin(Products, {"Product ID"}, Reviews, {"Product ID"}, "Reviews", JoinKind.Inner),
#"Expanded Reviews" = Table.ExpandTableColumn(Source, "Reviews", {"Source.Name", "Retailer", "Product ID", "Product Name", "Product URL", "Total Reviews", "Total Responses", "Rejected Responses", "Reviews, 1 Star", "Responses, 1 Star", "Reviews, 2 Stars", "Responses, 2 Stars", "Reviews, 3 Stars", "Responses, 3 Stars", "Reviews, 4 Stars", "Responses, 4 Stars", "Reviews, 5 Stars", "Responses, 5 Stars"}, {"Reviews.Source.Name", "Reviews.Retailer", "Reviews.Product ID", "Reviews.Product Name", "Reviews.Product URL", "Reviews.Total Reviews", "Reviews.Total Responses", "Reviews.Rejected Responses", "Reviews.Reviews, 1 Star", "Reviews.Responses, 1 Star", "Reviews.Reviews, 2 Stars", "Reviews.Responses, 2 Stars", "Reviews.Reviews, 3 Stars", "Reviews.Responses, 3 Stars", "Reviews.Reviews, 4 Stars", "Reviews.Responses, 4 Stars", "Reviews.Reviews, 5 Stars", "Reviews.Responses, 5 Stars"}),
#"Reordered Columns" = Table.ReorderColumns(#"Expanded Reviews",{"Brand", "Category", "Monitored Start Date", "Monitored End Date", "Engageable Start Date", "Engageable End Date", "Short Name", "Product Name", "Reviews.Product Name", "Attribute", "Reviews.Retailer", "Product ID", "Reviews.Source.Name", "Reviews.Product ID", "Reviews.Product URL", "Reviews.Total Reviews", "Reviews.Total Responses", "Reviews.Rejected Responses", "Reviews.Reviews, 1 Star", "Reviews.Responses, 1 Star", "Reviews.Reviews, 2 Stars", "Reviews.Responses, 2 Stars", "Reviews.Reviews, 3 Stars", "Reviews.Responses, 3 Stars", "Reviews.Reviews, 4 Stars", "Reviews.Responses, 4 Stars", "Reviews.Reviews, 5 Stars", "Reviews.Responses, 5 Stars"}),
#"Split Column by Delimiter" = Table.SplitColumn(#"Reordered Columns", "Reviews.Source.Name", Splitter.SplitTextByDelimiter("_", QuoteStyle.Csv), {"Reviews.Source.Name.1", "Reviews.Source.Name.2"}),
#"Changed Type" = Table.TransformColumnTypes(#"Split Column by Delimiter",{{"Reviews.Source.Name.1", Int64.Type}, {"Reviews.Source.Name.2", type text}}),
#"Removed Columns" = Table.RemoveColumns(#"Changed Type",{"Reviews.Source.Name.2", "Category"}),
#"Reordered Columns1" = Table.ReorderColumns(#"Removed Columns",{"Brand", "Monitored Start Date", "Monitored End Date", "Engageable Start Date", "Engageable End Date", "Reviews.Retailer", "Short Name", "Product Name", "Reviews.Product Name", "Attribute", "Product ID", "Reviews.Source.Name.1", "Reviews.Product ID", "Reviews.Product URL", "Reviews.Total Reviews", "Reviews.Total Responses", "Reviews.Rejected Responses", "Reviews.Reviews, 1 Star", "Reviews.Responses, 1 Star", "Reviews.Reviews, 2 Stars", "Reviews.Responses, 2 Stars", "Reviews.Reviews, 3 Stars", "Reviews.Responses, 3 Stars", "Reviews.Reviews, 4 Stars", "Reviews.Responses, 4 Stars", "Reviews.Reviews, 5 Stars", "Reviews.Responses, 5 Stars"}),
#"Renamed Columns" = Table.RenameColumns(#"Reordered Columns1",{{"Reviews.Retailer", "Site"}, {"Reviews.Source.Name.1", "YearMonthNum"}})

在 #“重命名的列”中

答案1

找到答案了：

“查看列出所有查询名称的查询和连接窗口，右键单击所需的查询名称，选择“加载到”选项，然后选择“表”选项”

相关内容