Hi Guys,
I am working with pulling data from Odata and choosing a specific table. I want to make the table it pulls from dynamic.
I want to be able to use a cell in Excel (e.g. A2) to store the name of the table.
Then I want the Excel query to include the cell reference.
So that, when I change the name of the table in A2, the query is automatically updated.
Any ideas?
Example of the Query:
let
Source = OData.Feed("https://********.svc"),
#"tablename_table" = Source{[Name="[B][COLOR=#FF0000]tablename[/COLOR][/B]",Signature="table"]}[Data]
in
#"tablename__table"
I am working with pulling data from Odata and choosing a specific table. I want to make the table it pulls from dynamic.
I want to be able to use a cell in Excel (e.g. A2) to store the name of the table.
Then I want the Excel query to include the cell reference.
So that, when I change the name of the table in A2, the query is automatically updated.
Any ideas?

Example of the Query:
let
Source = OData.Feed("https://********.svc"),
#"tablename_table" = Source{[Name="[B][COLOR=#FF0000]tablename[/COLOR][/B]",Signature="table"]}[Data]
in
#"tablename__table"