Forum Discussion
Solved
Can I refer to Table using String?
Here's what I tried to do that didn't work. Replace this: NewTable=#"MyTable" With this: TableName = "MyTable" NewTable = #TableName Is there something I can do along these li...
What I had in mind is to create a record for all tables you want to reference.
Query MyTables:
= [My Table = #"My Table", table1 = table1, table2 = table2]
The function that returns the table based on the name of the table:
= (table as text) as table => Expression.Evaluate(table,MyTables)
But why don't you just reference the tables as table? It's quit rare to reference a table by the name of the table.,
As far as I know this can't be done directly.
A workaround is to create a record with the table(s) you want to reference.
This record can then be used as so called "Environment" wit function Expression.Evaluate.
Query MyTables creates a record:
= [My Table = #"My Table"]
Query in which the table is referenced:
let
Source = "#""My Table""",
NewTable = Expression.Evaluate(Source, MyTables)
in
NewTable