Forum Discussion

KDEWALT's avatar
KDEWALT
New Member
3 years ago
Solved

APPEND USING M LANGUAGE IN ADVANCED EDITOR

I have 5 xlsx files with exact same headers but data is for different locations.  How do I append these files in one step directly using Advanced Editor.  i want to minimize the number of queries bui...
Need Help
  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    3 years ago

    Hi KDEWALT ,

    You can use Table.Combine function to append queries. In the function, add as many tables as you want.

    If you want to get a new table, create a new query like this:

    let
    Source = Table.Combine({Table, #"Table (2)", #"Table (3)", #"Table (4)", #"Table (5)"})
in
    Source

    If you want to add all other tables to one of the table for example the first table, add a step in the first table:

    #"Appended Query" = Table.Combine({#"Changed Type", #"Table (2)",#"Table (3)",#"Table (4)",#"Table (5)"})

    Best Regards,
    Community Support Team _ kalyj

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-yanjiang-msft's avatar
v-yanjiang-msft
Icon for Community Support rankCommunity Support
3 years ago

Hi KDEWALT ,

You can use Table.Combine function to append queries. In the function, add as many tables as you want.

If you want to get a new table, create a new query like this:

let
    Source = Table.Combine({Table, #"Table (2)", #"Table (3)", #"Table (4)", #"Table (5)"})
in
    Source

If you want to add all other tables to one of the table for example the first table, add a step in the first table:

#"Appended Query" = Table.Combine({#"Changed Type", #"Table (2)",#"Table (3)",#"Table (4)",#"Table (5)"})

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.