Adding the query name to a new column

[Anonymous]

Hello All,

I have a small question. As mentioned in the picture Iam looking for a solution where I can generate a new column in power query with the own query name in it. For example if my query name is ABCDE having a data of multiple columns and multiple rowa then I should have a new column that should be having the query name which is ABCDE  for each and every row. This should be reflected for each and every query in Power Query Editor. Can anyone please help me to find a formula for this one?

Note: Every query is not related to each other. Each and every query is independent.

[Anonymous]

Hi @rohit_singh 

I can't go forward from this step

Filter the name column using the name of the query and click on "Table" to expand the query. You will now see a reference to a specific row in the prevous step, which points to the query name.

That you have mentioned. I cant see any reference row.

[rohit_singh]

Hi @Anonymous ,

You can try using the "#sections" function in Power Query.

In Power Query, Go to "New Source" --> Blank Query. Then type in "= #sections"

Click on "Record". This will show you a list of all queries in your file. Convert this to a table

Filter the name column using the name of the query and click on "Table" to expand the query. You will now see a reference to a specific row in the prevous step, which points to the query name.

We will use this reference now to create a new column. Click on 'Add Column' and type in the specific row that we obtained previously.

This will create a new column with each row having a record datatype.

Expand the column and select the "Name" field

This gives us the query name in each row

Kind regards,

Rohit

Please mark this answer as the solution if it resolves your issue.
Appreciate your kudos! 🙂