Forum Discussion
MyQueries
Apr 22, 2021Copper Contributor
How to Get and add Power Query Table name in column
Hi All, I have imported data from multiple files data from multiple locations from SharePoint site. Ex table names are : Year 2015, Year 2016, Year 2017 ........ Now I want to add a new colu...
SergeiBaklan
Apr 22, 2021Diamond Contributor
Not sure I understood the question. There is Add custom column in the menu.
MyQueries
Apr 22, 2021Copper Contributor
For Example : Here I have 3 query tables , and now I want to add a new column with these query names in all 3 Query tables.
Right now I am adding manually adding these Query table names, but looking for a dynamic solution if we can add ?
- SergeiBaklanApr 22, 2021Diamond Contributor
Afraid you can't get current query name. However, querying SharePoint lists I guess you use parameters to define list name, why don't use the same parameter to add new column?