Forum Discussion
Eileen3524
Nov 09, 2021Copper Contributor
Adding Column in Excel Table with text inputs
I created a excel table using Power Query in Excel and added a column to within excel to the table and not part of power query. I wanted to use this column to add a text comment. However, anytime I...
SergeiBaklan
Nov 09, 2021Diamond Contributor
Yes, if you have unique ID for each record in query. You return source query, add column with comments, query such table again and merge with initial one. All shall be done as steps with one query, not as separate ones. More details is here Self Referencing Tables in Power Query - Excelerator BI
Eileen3524
Nov 10, 2021Copper Contributor
SergeiBaklan That worked! Thanks for your help.
- SergeiBaklanNov 10, 2021Diamond Contributor
Eileen3524 , you are welcome