Forum Discussion
Name a Table from a Column Value
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
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
Hi
So the code I provided allows me to create a new query for each row, what I am trying to achieve, as this file is a template file to be distributed to colleagues, if I create 8 new queries named Query 1, Query 2, Query 3 etc can I rename the query using code to the value in the column named asset
e.g. Query 1 renamed to T-16 441 using code
Thanks