當我在作業結束時使用高級編輯器應用相同的確切步驟時，我正在 Power Query 中創建應用步驟。
From Split Column by delimiter8 是使用高級編輯器的開始。
問題是我重繪 時的最終表格，只顯示第 10 列，訂單專案 10.1、訂單數量 10.2 和訂單價格 10.3。何時應將相同的原則應用于訂購專案 6 至 10。請參見下圖。理想情況下，我希望看到 6.1 / 6.2 / 6.3 /7.1 / 7.2 / 7.3 重復到 10。
你能幫助我嗎？我會盡快回復任何回復。
表布局
我的代碼如下 -
#"Changed Type16" = Table.TransformColumnTypes(#"Split Column by Delimiter8",{{"Order Items.6.1", type text}, {"Order Items.6.2", Int64.Type}, {"Order Items.6.3", Int64.Type}}),
#"Renamed Columns10" = Table.RenameColumns(#"Changed Type16",{{"Order Items.6.2", "Order Quantity.6.2"}, {"Order Items.6.3", "Order Price.6.3"}}),
#"Changed Type17" = Table.TransformColumnTypes(#"Renamed Columns10",{{"Order Price.6.3", Currency.Type}}),
#"Split Column by Delimiter9" = Table.SplitColumn(#"Changed Type15", "Order Items.7", Splitter.SplitTextByDelimiter(":", QuoteStyle.Csv), {"Order Items.7.1", "Order Items.7.2", "Order Items.7.3"}),
#"Renamed Columns11" = Table.RenameColumns(#"Split Column by Delimiter9",{{"Order Items.7.2", "Order Quantity.7.2"}, {"Order Items.7.3", "Order Price.7.3"}}),
#"Changed Type18" = Table.TransformColumnTypes(#"Renamed Columns11",{{"Order Quantity.7.2", Int64.Type}, {"Order Price.7.3", Currency.Type}}),
#"Split Column by Delimiter10" = Table.SplitColumn(#"Changed Type15", "Order Items.8", Splitter.SplitTextByDelimiter(":", QuoteStyle.Csv), {"Order Items.8.1", "Order Items.8.2", "Order Items.8.3"}),
#"Renamed Columns12" = Table.RenameColumns(#"Split Column by Delimiter10",{{"Order Items.8.2", "Order Quantity.8.2"}, {"Order Items.8.3", "Order Price.8.3"}}),
#"Changed Type19" = Table.TransformColumnTypes(#"Renamed Columns12",{{"Order Quantity.8.2", Int64.Type}, {"Order Price.8.3", Currency.Type}}),
#"Split Column by Delimiter11" = Table.SplitColumn(#"Changed Type15", "Order Items.9", Splitter.SplitTextByDelimiter(":", QuoteStyle.Csv), {"Order Items.9.1", "Order Items.9.2", "Order Items.9.3"}),
#"Renamed Columns13" = Table.RenameColumns(#"Split Column by Delimiter11",{{"Order Items.9.2", "Order Quantity.9.2"}, {"Order Items.9.3", "Order Price.9.3"}}),
#"Changed Type20" = Table.TransformColumnTypes(#"Renamed Columns13",{{"Order Quantity.9.2", Int64.Type}, {"Order Price.9.3", Currency.Type}}),
#"Split Column by Delimiter12" = Table.SplitColumn(#"Changed Type15", "Order Items.10", Splitter.SplitTextByDelimiter(":", QuoteStyle.Csv), {"Order Items.10.1", "Order Items.10.2", "Order Items.10.3"}),
#"Renamed Columns14" = Table.RenameColumns(#"Split Column by Delimiter12",{{"Order Items.10.2", "Order Quantity.10.2"}, {"Order Items.10.3", "Order Price.10.3"}}),
#"Changed Type21" = Table.TransformColumnTypes(#"Renamed Columns14",{{"Order Quantity.10.2", Int64.Type}, {"Order Price.10.3", Currency.Type}})
uj5u.com熱心網友回復：
這是因為您在任何地方都參考了相同的步驟 #"Changed Type15" 并且所有中間結果都被簡單地覆寫了。當您查看第一步時（此處未顯示），每一行都取決于前一步。
轉載請註明出處，本文鏈接：https://www.uj5u.com/gongcheng/367246.html
上一篇：ApachePOI-“超出單元格樣式的最大數量”的影響是什么。您最多可以在.xlsx作業簿中定義64000個樣式
下一篇：Excel計算今天列中的特定數字