= Table.Group(Source, {"LetterColumn"}, {{"Column", each Text.Combine(List.Transform(_[NumberColumn], (x) => Number.ToText(x)), ","), type text}})
Table.Group
执行分组操作,生成一个由所有具有相同LetterColumn值的行组成的表格。 _[NumberColumn]
给出了此新表中NumberColumn列中的值列表。 List.Transform
将数字转换为文本值, Text.Combine
将这些数字连接在一起,并用逗号隔开每个值。= Table.Group(Source, {"LetterColumn"}, {{"Column", each """" & Text.Combine(List.Transform(_[NumberColumn], (x) => Number.ToText(x)), ",") & """", type text}})
""""
代表 "字符, & 将两个文本值组合在一起。我们可以直接得到这个结果,几乎是我们想要的:
= Table.Group(Source,
{"LetterColumn"},
{{"NearlyGoodToGo", each List.Sum([NumberColumn]), type number}})
现在,需要直接更改代码的两个地方:
Text.Combine(List.Transform([NumberColumn], Text.From), ",")
替换List.Sum[NumberColumn]
type text
替换type number
我认为这是利用GUI获取基本模板,然后调整代码以避免使用GUI的All Rows操作和它产生的嵌套表格。
演示
let
Source = Table.FromColumns({{"A","A","A","B","B","C","C","C","C"},{1..9}}, type table[LetterColumn = Text.Type, NumberColumn = Number.Type]),
#"Grouped Rows" = Table.Group(Source, {"LetterColumn"}, {{"GoodToGo", each Text.Combine(List.Transform([NumberColumn], Text.From), ","), type text}})
in
#"Grouped Rows"
Results
each Text.Combine(List.Transform(_, Text.From), ...)
- 字面上是点点点,尽管已经选择了逗号。如果我将“...”更改为“,”,世界秩序就会恢复... - Jerry Norbury