Forum Discussion

torman119's avatar
torman119
New Member
6 years ago
Solved

Dynamically combine multiple tables into one table

I need to combine several tables from Azure storage dynamically into one table. I have for instance the following dynamically created tables: userstable564736 userstable595743 userstable434534 ot...
Need Help
  • torman119's avatar
    torman119
    6 years ago

    Following solution works

     

    let
       Source = AzureStorage.Tables("https://storageaccount.table.core.windows.net"),
       usertables = Table.SelectRows(Source, each Text.StartsWith([Name], "userstable")),
       combined= Table.Combine(usertables[Data])
    in
       combined

torman119's avatar
torman119
New Member
6 years ago

Following solution works

 

let
   Source = AzureStorage.Tables("https://storageaccount.table.core.windows.net"),
   usertables = Table.SelectRows(Source, each Text.StartsWith([Name], "userstable")),
   combined= Table.Combine(usertables[Data])
in
   combined