self referencing table_power query

[Ari_25]

Help please... have check a post here and it is practically what I need but it is not working for me.
I have table called Shipout that gets data from a power query. I added additional columns manually to the table, but when data refreshes, the data I manually entered, it stays in the same row I entered it and doesnt move with its row. here the procedureI followed.

Self Referencing Tables in Power Query

Learn how to use self referencing tables in Power Query to allow you to add comments directly into a Power Query table, as part of the table.

exceleratorbi.com.au

 

[vletm]

Moderator Note:
Are You sure that Your link goes to single file?
... Your link give other kind of image.
Anyway, for others, it's more safe to send a file here.

 

[GraH - Guido]

Help please... have check a post here and it is practically what I need but it is not working for me.
I have table called Shipout that gets data from a power query. I added additional columns manually to the table, but when data refreshes, the data I manually entered, it stays in the same row I entered it and doesnt move with its row. here the procedureI followed.

Self Referencing Tables in Power Query

Learn how to use self referencing tables in Power Query to allow you to add comments directly into a Power Query table, as part of the table.

exceleratorbi.com.au

Not sure how you are doing this, better to upload your file here, so at least we can see the code.
Since your lines "jump", it means you are most likely not joining correctly, or you have built it in an incorrect way.

Assume this input table "in".

ID	Name
1	John
2	Carl
3	Ester
4	Yasmin
5	Ziggy

It's loaded on a different sheet, and you've added comments.

ID	Name	Comment
1​	John
2​	Carl	Organized a pool competetion
3​	Esther
4​	Yasmin	Is going hicking around the world
5​	Ziggy

Now data is added and changed:

ID	Name
2​	Carl
3​	Esther
4​	Yasmin
5​	Ziggy
6​	John
20​	Ester

let
    Updated_table = Excel.CurrentWorkbook(){[Name="in_1"]}[Content],
    Source = Excel.CurrentWorkbook(){[Name="in"]}[Content],
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"ID", Int64.Type}, {"Name", type text}}),
    #"Merged Queries" = Table.NestedJoin(#"Changed Type", {"ID", "Name"}, Updated_table, {"ID", "Name"}, "Updated_table", JoinKind.LeftOuter),
    Expand_updated_table = Table.ExpandTableColumn(#"Merged Queries", "Updated_table", {"Comment"}, {"Comment"})
in
    Expand_updated_table

In my example "Comment" is first loaded twice when you do the first refresh. Delete the one that's named "Comment2".