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

Vijay_A_Verma's avatar
Vijay_A_Verma
Most Valuable Professional
4 years ago

You need to change the statement before in to (hence only change is from Name to Content)

CombTable=Table.Combine(SelTables[Content])

Hence, final code will be 

let
  Quelle = Excel.CurrentWorkbook(),
  SelTables = Table.SelectRows(Quelle, each Text.StartsWith([Name], "Ref_")),
  CombTable=Table.Combine(SelTables[Content])
in
  CombTable