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

othertable434342

othertable342856

 

I want to combine all tables which start with "userstable" into a single table. All these user tables have same schema. I don't know the full names of them upfront.

 

I tried this:

 

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

 

But I get error message

Expression.Error: There is an unknown identifier. Did you use the [field] shorthand for a _[field] outside of an 'each' expression?

 

Can somebody help?

    

1 Reply