JackDanIce
Well-known Member
- Joined
- Feb 3, 2010
- Messages
- 9,922
- Office Version
- 365
- Platform
- Windows
Hi,
I have four identical columns and wish to combine them into a master table where:
I add a column to each table
Fill this column with the table name
Apend and repeat
Query is called Single_Table and so far I have:
But I can't get the table name to fill a blank column.
After this, I wish to create a table like:
source = Table.Apend(Single_Table("Sales"), Single_Table("Purchases"), Single_Table("Revenue_Earned"), Single_Table("Revenue_Expensed")
How can I use the table name as a value for a column add?
TIA,
Jack
I have four identical columns and wish to combine them into a master table where:
I add a column to each table
Fill this column with the table name
Apend and repeat
Query is called Single_Table and so far I have:
Power Query:
(table_name)=>
let Source = Table.ReorderColumns(Table.AddColumn(table_name, "Book", each table_name),{"Book", "Ledger", "Operation Unit Code", "Operation Unit Name", "Country", "Amount (CAD)", "TPM", "Comment"})
in
Source
After this, I wish to create a table like:
source = Table.Apend(Single_Table("Sales"), Single_Table("Purchases"), Single_Table("Revenue_Earned"), Single_Table("Revenue_Expensed")
How can I use the table name as a value for a column add?
TIA,
Jack