Table Join and Alias in Power Query - EXCEL

**grcshekar** · 01-29-2023, 02:27 AM

Hi

I have 2 tables namely Table_1, Table_2 having Columns ID, Name
I want to join these two and get output as Table_1_ID, Table_1_Name, Table_2_ID, Table_2_Name

How should I write the Power Query for this

**sandy666** · 01-29-2023, 02:37 AM

see this

Append queries

Merge queries

Table Join and Alias in Power Query - EXCEL

LinkBack

Thread Tools

Rate This Thread

Display

Table Join and Alias in Power Query - EXCEL

Re: Table Join and Alias in Power Query - EXCEL

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Excel Power query Buffer Table , Where and when,

Reference your excel formula to power query table

[SOLVED] Power Query - Join Two tables using NOT EQUAL criteria

[SOLVED] How to add an Excel formula code into Power Query or create a new one in Power Query

Sub-Forum for Excel Power Tools (Power Query, Power Pivot & Power BI)

[SOLVED] Is there a way to add a normal excel formula to a Power Query Table

Odbc table join or calculated fields in ms query excel

Bookmarks

Bookmarks

Posting Permissions