Forum Discussion
Combine power query output table with manually maintained column in one excel table
Zdenek_Moravec Not too long ago, similar questions came up on this forum. Both were responded to by
Thought the technique to do this would come in handy but didn't think it was very straight-forward. So, I created some kind of tutorial for myself, writing the process down step-by-step. And it includes a working, tough very simple, example. See attached.
Zdenek_Moravec Not too long ago, similar questions came up on this forum. Both were responded to by
Thought the technique to do this would come in handy but didn't think it was very straight-forward. So, I created some kind of tutorial for myself, writing the process down step-by-step. And it includes a working, tough very simple, example. See attached.
Riny_van_Eekelen , I modified a bit, hope self-explainable
let
Source = Excel.CurrentWorkbook(){[Name="Source"]}[Content],
Source3 = Excel.CurrentWorkbook(){[Name="Source3"]}[Content],
SourceColumns = Table.ColumnNames(Source),
SourceColumns3 = Table.ColumnNames(Source3),
FirstTime = List.ContainsAll(SourceColumns, SourceColumns3),
Return = if FirstTime then Source else
Table.Join(
Source, SourceColumns,
Source3, SourceColumns
)
in
Return
Another table in your file.
SergeiBaklan I didn't understand the use of the third table and how does it integrates with the rest of the solution...
Please ignore. That was attempt to use Table.Join() instead of Table.NestedJoin(). But the former not always returns correct result.
SergeiBaklan Nice!!
Hello Riny_van_Eekelen and SergeiBaklan
Your solutions are already an Excel University, but it is understandable and it really works 😉
Thank You very much!
Zdenek Moravec
Cesky Krumlov, Czech Republic
Zdenek_Moravec , glad to help
