Forum Discussion
Solved
Combine power query output table with manually maintained column in one excel table
I transform and load a CSV file into an excel sheet using Power Query: Column1 Column2.1 Column2.2 01.01.2021 A BC 01.02.2021 M NO 01.03.2021 X YZ Cus...
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 SergeiBaklan
In case if there is new data being added and same time we have to implement this method as well, Would it work?
Not sure I understood what do you mean exactly. If you add columns to the table returned by Power Query and your date have unique ID (or you may create it) - yest, it works.