Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
smann
Helper I
Helper I

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 lines? Thanks!

1 ACCEPTED SOLUTION
MarcelBeug
Community Champion
Community Champion

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.,

Specializing in Power Query Formula Language (M)

View solution in original post

5 REPLIES 5
MarcelBeug
Community Champion
Community Champion

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
Specializing in Power Query Formula Language (M)

thanks for the reply @MarcelBeug

 

I didn't quite follow what you said (very new to power query and rusty on this stuff in general), but I think I got the gist. I made a function that takes a string and returns a table based on a bunch of if statements (e.g. if string="table1" then #"table1" else if string="table2" then #"table2" etc).

 

let me know if that's what you had in mind. it's working so far as a workaround

MarcelBeug
Community Champion
Community Champion

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.,

Specializing in Power Query Formula Language (M)

@MarcelBeug got it, thanks. It's a very specific situation: I want to pull in a table from a csv and use that to check values in various tables. So one of the columns from the csv is the table name. To automate it, I want to use that column to refer to my tables rather than hard-coding for each table

MarcelBeug
Community Champion
Community Champion

Thanks for clarifying the context. Well appreciated

Specializing in Power Query Formula Language (M)

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.