Forum Discussion
Merging Queries
Hi Anonymous
You can select multiple matching columns by selecting Ctrl key as you select the columns. When you do so, the order in which the columns were selected is displayed in small numbers next to the column headings, starting with 1.
In below sample, first select the Name column in the Table1 table, click and hold on Ctrl key, and then select the Date column. (This will show the small numbers in the column headings.) Next, perform the same selections in the Table2 table. The following image shows the result of selecting those columns.
You can refer to this article for more guidance: Merge queries overview - Power Query | Microsoft Docs
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
In Power Query you can create merge using multiple criteria (CTRL + left clic)
Hi,
I am not able to create a power query. Can you explain the process in a little detailed manner? Thanks 🙂
Can you send some data I will give you a power bi file ?
Hi Anonymous
You can select multiple matching columns by selecting Ctrl key as you select the columns. When you do so, the order in which the columns were selected is displayed in small numbers next to the column headings, starting with 1.
In below sample, first select the Name column in the Table1 table, click and hold on Ctrl key, and then select the Date column. (This will show the small numbers in the column headings.) Next, perform the same selections in the Table2 table. The following image shows the result of selecting those columns.
You can refer to this article for more guidance: Merge queries overview - Power Query | Microsoft Docs
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.