Forum Discussion

Richard_Halsall's avatar
Richard_Halsall
Helper IV
1 year ago
Solved

Name a Table from a Column Value

Hi   Is there a way to name a table based on a column value in that table   I have a grouped table of data as below named AssetActivity In a new query I have this code   let Source = if...
Need Help
  • PwerQueryKees's avatar
    PwerQueryKees
    1 year ago

    I can not reproduce your behaviour. The code snippet you gave is not complete, so I guess there is more happening.

    BUT,

    You will always have to manuall create a new query for each row. 
    Given that...

    Starting with:

    Rightclick on the Table in any line and "Add as New Query

    Will produce this new query:



    Did I answer your question? Then please (also) mark my post as a solution and make it easier to find for others having a similar problem.
    Remember: You can mark multiple answers as a solution...
    If I helped you, please click on the Thumbs Up to give Kudos.

    Kees Stolker

    A big fan of Power Query and Excel

     

     

PwerQueryKees's avatar
PwerQueryKees
Super User
1 year ago

Still not entirely sure what you want to achieve, but NO, you can not rename a query by code on PowerQuery.

If you are working in Excel, you CAN use VBA to rename queries, but you will not hav access to the query results in VBA...

Kees Stolker

A big fan of Power Query and Excel