After merging multiple queries, how do I make a custom column that shows which query each record is sourced from?
Example:
I am new to Power Query and I have no clue how to achieve this.
Hi @Syndicate_Admin ,
Apologies for the confusion, the example I gave is just a visualization of what I want to achieve because I need it to be dynamic. My merged table consists of multiple left outer merges and I need to label each record which query matches the record in a Source column.
mmbr1606
9
Super User 2025 Season 1
stampcoin
7
SD-13050734-0
6