How to Get and add Power Query Table name in column

[Rajender Singh]

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 column in respective tables names. 

Can anybody suggest me , if there is any workaround or custom M code ?

[#2]

@Rajender Singh 

Not sure I understood the question. There is Add custom column in the menu.

[#3]

@Sergei Baklan 

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 ? 

[#4]

@Rajender Singh 

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?