Combine two tables vertical

[4ndreas]

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

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:

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]

I could solve it with the following approach:

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]

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.