Forum Discussion

umtkyn's avatar
umtkyn
Regular Visitor
2 years ago
Solved

list all tables' names dynamically

hi,   Is there a way to create a list of all tables' names dynamically in an excel file with powerquery ?   Thanks,
Need Help
  • AntrikshSharma's avatar
    AntrikshSharma
    2 years ago

    umtkyn You can use the path of the current file and then filter for Tables.

     

    let
    Source = Excel.Workbook ( File.Contents ( "C:\Users\antsharma\Downloads\1.xlsx" ) ),
    TableNames = Table.SelectRows ( Source, each [Kind] = "Table" )[[Name]]
in
    TableNames

     

umtkyn's avatar
umtkyn
Regular Visitor
2 years ago

thank you, i was actually trying to append all the tables in it and i found a solution... for future reference i write it also here...

 

 

Source = Excel.Workbook(File.Contents("C:\Users\777\filename.xlsx"), null, true),
#"Filtered Rows" = Table.SelectRows(Source, each ([Kind] = "Table")),
CombineTable= Table.Combine(#"Filtered Rows"[Data])