Hi, i'm trying to combine selected Tables from my current Workbook. For Example: [Worksheet AW01]Table "Ref_AW01":RowDataTextValue1 1AAAAA0,7 2BBBBB2,3 [Worksheet AW02]Table "Ref_AW02":RowDataTextValue1 1CCCCC0,01 2DDDD1,2 3EEEEE5,6 I like to combine all Tables in the Workbook named like "Ref_*" toSource RowDataTextValue1AW011AAAAA0,7AW012BBBBB2,3AW021CCCCC0,01AW022DDDD1,2AW023EEEEE5,6..... AW9834 So i tried:let Quelle = Excel.CurrentWorkbook(), SelTables = Table.SelectRows(Quelle, each Text.StartsWith([Name], "Ref_")), CombTable=Table.Combine(SelTables[Name])in CombTable This raises the follwoing Error:Expression.Error: Der Wert ""Ref_AW01"" kann nicht in den Typ "Table" konvertiert werden. ~> The value "Ref_AW01"" can't be converted to type "Table"Details:Value=Ref_AW01Type=[Type] The other Question is, how can i add a column in each Table named like the Table as Source-Reference? Thanks in advance for any hints and tips!Best regards,Heiko

Hi The column containing the data in your sample file is called [Content] and not [Name] so the query shoul be like this let Quelle = Excel.CurrentWorkbook(), SelTables = Table.SelectRows(Quelle, each Text.StartsWith([Name], "Ref_")), CombTable=Table.Combine(SelTables[Content]) in CombTable Hope this helps you /Erik

Combine Tables from CurrentWorkbook | Microsoft Fabric Community

Forum Discussion

Related content

Tables combine

Conditional table combine

table combine

Combining three CONCATENATEX Measures with results from two Tables

Dynamic RLS combination