Forum Discussion

hwoehrle's avatar
hwoehrle
Frequent Visitor
4 years ago
Solved

Combine Tables from CurrentWorkbook

Hi,   i'm trying to combine selected Tables from my current Workbook. For Example:   [Worksheet AW01] Table "Ref_AW01": Row DataText Value1   1 AAAAA 0,7   2 BBBBB 2,3   ...
Need Help
  • donsvensen's avatar
    donsvensen
    4 years ago

    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

hwoehrle's avatar
hwoehrle
Frequent Visitor
4 years ago

Hi Erik,

 

thanks for your reply!

Since there are many tables (with quite a lot columns) i want to combine, i guess the Table.ExpandTableColumn won't do the job.

 

With TableCombine i tried to combine all the selected Tables -> SelTables

CombTable=Table.Combine(SelTables[Name]) as you suggested. Or i misunderstand you.

 

Maybe you can take a look at the example file?

SampleFile 

 

 

 

donsvensen's avatar
donsvensen
Skilled Sharer
4 years ago

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