Combine two tables vertical

4ndreas · Jan 15, 2020

Hi,
I have two web-queries:
1. Query:

Code:

let    Quelle = Web.Page(Web.Contents("https://www.ariva.de/henkel_vz-aktie/bilanz-guv?page=6")),
    Data10 = Quelle{10}[Data]
in
    Data10

2. Query:

Code:

let    Quelle = Web.Page(Web.Contents("https://www.ariva.de/henkel_vz-aktie/bilanz-guv?page=0")),
    Data10 = Quelle{10}[Data]
in
    Data10

From the first query I get a table with values from the years 2008 to 2013. The second query gives me the values from 2014 to 2019.
(How) can I combine the table columns vertical to get all years (2008 to 2019) in one table?

Thanks
Andreas

4ndreas · Jan 15, 2020

I could solve it with the following approach:

Code:

let    Quelle = #"Table 1",
    #"Zusammenführte Abfragen" = Table.NestedJoin(Quelle,{"Column1"},#"Table 2",{"Column1"},"Table 2",JoinKind.LeftOuter),
    #"Erweiterte Table 2" = Table.ExpandTableColumn(#"Zusammenführte Abfragen", "Table 2", {"Column2", "Column3", "Column4", "Column5", "Column6", "Column7"}, {"Column2.1", "Column3.1", "Column4.1", "Column5.1", "Column6.1", "Column7.1"})
in
    #"Erweiterte Table 2"

Thanks

Ken Puls · Jan 16, 2020

Hi 4ndreas,

I believe you chose the Merge option. That's for horizontal joins, not vertical ones. The option you want is actually the Append option.

Right click your first query, choose Append (instead of Merge), choose the second query and you should be good to go.

Combine two tables vertical

4ndreas

New member

4ndreas

New member

Ken Puls

Administrator