Sintaxe
M
Table.ExpandTableColumn(table as table, column as text, columnNames as list, optional newColumnNames as nullable list) as tableParâmetros
- tabletableObrigatório
Tabela com a coluna de tabelas aninhadas.
MTable.FromRecords({...})- columntextObrigatório
Coluna a expandir.
M"Locations"- columnNameslistObrigatório
Colunas da tabela interna a expandir.
M{"City", "State"}- newColumnNamesnullable listOpcional
Nomes para as novas colunas.
M{"Locations.City", "Locations.State"}
Retorna
tableExemplo
M
Table.ExpandTableColumn(
Table.FromRecords({
[
Company = "Contoso",
Locations = Table.FromRecords({
[City = "Redmond", State = "WA"],
[City = "Bellevue", State = "WA"],
[City = "Tempe", State = "AZ"]
})
]
}),
"Locations",
{"City", "State"},
{"Locations.City", "Locations.State"}
)Resultado
M
Table.FromRecords({
[Company = "Contoso", Locations.City = "Redmond", Locations.State = "WA"],
[Company = "Contoso", Locations.City = "Bellevue", Locations.State = "WA"],
[Company = "Contoso", Locations.City = "Tempe", Locations.State = "AZ"]
})Mais informações
- Subgrupo
- Table