List.TransformMany

Syntax

List.TransformMany(
    list as list,
    collectionTransform as function,
    resultTransform as function
) as list

About

返回一个列表，该列表的元素从输入列表中投影。

该 collectionTransform 函数将每个元素转换为中间列表，该 resultTransform 函数接收原始元素以及中间列表中的项，以便构造最终结果。

该 collectionTransform 函数具有签名 (x as any) as list => ...，其中 x 是一个元素 list。 该resultTransform函数投影结果的形状，并具有签名(x as any, y as any) as any => ...，其中是x一个元素，list并且y是通过传递给xcollectionTransform生成的列表中的元素。

示例 1

平展一系列人及其宠物。

用法

List.TransformMany(
    {
        [Name = "Alice", Pets = {"Scruffy", "Sam"}],
        [Name = "Bob", Pets = {"Walker"}]
    },
    each [Pets],
    (person, pet) => [Name = person[Name], Pet = pet]
)

输出

{
    [Name = "Alice", Pet = "Scruffy"],
    [Name = "Alice", Pet = "Sam"],
    [Name = "Bob", Pet = "Walker"]
}