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

     

AntrikshSharma's avatar
AntrikshSharma
Community Champion
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

how do you manage if you need to do it in the same file ?