Power Query Adding a custom collumn (for comments)

[Thys90]

Hi There,

I'm pretty new to this and figuring it our along the way.
I'm creating on a excel file that loads data from our ERP system (csv file).
I have multiple tabs for the different departments.

I would like to have a collumn added where colleague's can add a comment about a specific line.
But when I refresh, all the data changes (which I want), but the comments stay on the same place (so don't correspondences with the line where it was related to).

I already tried to add an null collumn (but that of course overrides the comment).

Does anyone have an idea how to add such a collumn?

Thanks!!
Thijs

 

[Automatrix]

I would like to do that too, but I'm afraid it isn't possible in Power Query.

 

[GraH]

It actually is possible. I posted this several times already.

Make the query as you need.
Load as table to Excel.

Reload this table in Power Query.
Go to the advanced editor and copy the source step. Close this Query.
open the original one, also in the advanced editor.
paste the code as first step. Rename it, since you can't have 2 steps named source. Use commented or so.
As last step do a merge with the 2nd Query and link as appropriate. Expand the table with the comment field.
in the step with the merge action replace that part of the code where you see the name of the second Query and replace with the first step name. E.g. commented.

save and load the query.

Finally delete the second Query as you only creatief it to know the code to paste.

on YouTube you may find tutorials doing just this.