Dec 11 2020 06:30 PM
I need to add a blank column in the table resulting of a query that will allow information to be entered, sorted and filtered.
When I add the column, when I sort, the information does not follow the row it was entered in.
I tried the instruction at this link but without success Problem with manually added column in a table connected to a query | MrExcel Message Board
Can you help me?
Dec 12 2020 03:34 AM
Table returned by Power Query is not in sync with manually added column. However, you may sync if you have ID for your records or any unique field. Generate table by Power Query first time, add manual column, query resulting table. Merge initial query with this one by ID and expand manual column. Now you shall to combine that into one initial query. Refresh, if extra column appears remove it. Resulting script shall be like
let
Source = Excel.CurrentWorkbook(){[Name="Source"]}[Content],
Source2 = Excel.CurrentWorkbook(){[Name="Source_2"]}[Content],
#"Merged Queries" = Table.NestedJoin(Source, {"ID"}, Source2, {"ID"}, "Source2", JoinKind.LeftOuter),
#"Expanded Source2" = Table.ExpandTableColumn(#"Merged Queries", "Source2", {"Note"}, {"Note"})
in
#"Expanded Source2"
Please see attached sample.