Forum Discussion

Copper Contributor

Mar 28, 2020

Power Query Union Tablas sin Campos en Comun

Buenas tardes, quiero armar una consulta uniendo dos tablas: Tabla 1 (dos campos ID y Nro) ID Nro A 1 B 2 Tabla 2 (un campo PAIS) PAIS Ale Ita Fran Quiero generar una union ...

Diamond Contributor

Mar 28, 2020

Exemilenio

With this sample

query could be

let
    Source = Excel.CurrentWorkbook(){[Name="IDs"]}[Content],
    Country = Excel.CurrentWorkbook(){[Name="Country"]}[Content],

    AddListOfCountries = Table.AddColumn(
        Source,
        "Country",
        each Country[Country]
    ),
    ExpandCountries = Table.ExpandListColumn(
        AddListOfCountries,
        "Country"
    ),
    SortByCountry = Table.Sort(
        ExpandCountries,
        {{"Country", Order.Ascending}}
    )
in
    SortByCountry