I currently have the likes of:
Code:
let
    Table1= Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    Table2= Excel.CurrentWorkbook(){[Name="Table2"]}[Content],
    Table3= Excel.CurrentWorkbook(){[Name="Table3"]}[Content],
    Table4= Excel.CurrentWorkbook(){[Name="Table4"]}[Content],
    Table5= Excel.CurrentWorkbook(){[Name="Table5"]}[Content],
    Table6= Excel.CurrentWorkbook(){[Name="Table6"]}[Content],
    Source = Table.Combine({Table1, Table2, Table3, Table4, Table5, Table6}),
…
Is it possible to condense the six CurrentWorkbook lines into one CurrentWorkbook statement so that ultimately I might end up with (I know it's wrong) the likes of:
Code:
Source = Table.Combine(Excel.CurrentWorkbook(){Table1,Table2,Table3,Table4,Table5,Table6}[Content]),
I realise I could use Excel.CurrentWorkbook() on its own and later filter the list and expand. Also I could probably:
Code:
Source = Table.Combine({Excel.CurrentWorkbook(){[Name="Table1"]}[Content], Excel.CurrentWorkbook(){[Name="Table2"]}[Content], Excel.CurrentWorkbook(){[Name="Table3"]}[Content], Excel.CurrentWorkbook(){[Name="Table4"]}[Content], Excel.CurrentWorkbook(){[Name="Table5"]}[Content], Excel.CurrentWorkbook(){[Name="Table6"]}[Content]}),
I was wondering whether there was a syntax for mutliple, hard-coded table names to be included in one Excel.CurrentWorkbook statement? (The Power Query's functions Help is no help on this, not even mentioning the single table syntax.)