Is there a way to Merge tables from the same query

[sara121]

Hi everyone,

In the same query, I transformed two tables, how do I merge these two tables into one?
The MERGE function I saw is to merge tables from two queries.

Can someone shed some light?

Thank you!

 

[jdellasala]

Absolutely! Just select the same query:

The sample above also illustrates using two columns as keys.

 

[sara121]

Thanks. jdellasala!

I may not be clear about my original question as I'm still new to the power query.

In the same query, I transformed a data set in a step #"Create_DEBIT" (In this table, it has Debit and Date) and subsequently I created another step #"Create_CREDIT" (in this table, it has Credit and Date)

I'd like to merge the two into one table. and I wonder how I can do it within the query.

​

​

 

[jdellasala]

Thanks. jdellasala!

I may not be clear about my original question as I'm still new to the power query.

In the same query, I transformed a data set in a step #"Create_DEBIT" (In this table, it has Debit and Date) and subsequently I created another step #"Create_CREDIT" (in this table, it has Credit and Date)

I'd like to merge the two into one table. and I wonder how I can do it within the query.

​

​

The easy way is to just duplicate the query and make one query Debit, and the other Credit and then merge them.
If you're into manually altering the M Code, when you Merge the query with itself, the code will look like this:

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    Debit = Table.SelectColumns(Source,{"Column1", "Column2"}),
    Credit = Table.SelectColumns(Source,{"Column3", "Column4"}),
    MergedSelf = Table.NestedJoin(Credit, {"Column3"}, Credit, {"Column3"}, "Credit", JoinKind.LeftOuter)
in
    MergedSelf

Modify the Merged Self line to merge with the Debit Table, Column1:

    MergedCrditDebit = Table.NestedJoin(Credit, {"Column3"}, Debit, {"Column1"}, "Credit", JoinKind.LeftOuter)

When I first tried it, I just changed the name of the second table from "Credit" to "Debit" but forgot to change the key column name which needed to be a valid column in the Debit table - either Column1 or Column2.