如何同时展开一行列表中的所有列表? [英] How can I expand all lists in a row of lists at the same time?
问题描述
我想一次扩展此表中的所有列表而不必显式命名(硬编码)每一列.我确实想假设所有列在行中都有一个列表.我还希望能够将解决方案应用于列数比示例中少或多的表.该表可能会减少或增加其列数,并且列的名称可能会更改,这就是我不想使用显式列名称的原因.
我在各种论坛站点上找到了一些关于一次扩展多个列表的主题,但它们都不仅仅涉及执行我上面描述的操作,而且都在某种程度上使我感到困惑,因为我已经尝试过使它们适合我的需要.
@MarcelBeug 在
那我该怎么做?
您希望跨每列聚合 Table.ExpandListColumn
函数:
letSource = #table({"A", "B"}, {{ {1,2}, {3,4}} }),扩展 = List.Accumulate(Table.ColumnNames(来源),来源,(状态,列)=>Table.ExpandListColumn(state, column))在展开
I would like to expand all of the lists in this table at once without having to explicitly name (hard-code) each column. I do want to assume that all columns have a list in the row. I also want to be able to apply the solution to a table with less or more columns than are in the example. The table might decrease or increase its number of columns and the columns' names might change, which is why I don't want to use explicit column names.
I've found a few threads about expanding multiple lists at once, at various forum sites, but they all address more than just doing what I describe above and have all confused me to one degree or another as I've tried to fit them to my need.
@MarcelBeug provides a detailed solution at this site (as do other folks too). I'm using @MarcelBeug's function, and it works great; but I'd like to tailor it to just what I'm seeking, as mentioned above, and I'm having trouble doing that.
So how do I do this?
You want to aggregate the Table.ExpandListColumn
function across each column:
let
Source = #table({"A", "B"}, {{ {1,2}, {3,4}} }),
Expanded = List.Accumulate(
Table.ColumnNames(Source),
Source,
(state, column) => Table.ExpandListColumn(state, column))
in
Expanded
这篇关于如何同时展开一行列表中的所有列表?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!