Forum Discussion
Insert new columns to SQL query data table in Excel
Hi All,
I have created a table in excel using a SQL query. Also, I have inserted a column in the table that needs to be populated manually.
The problem is when the query is updated; the added manual information stays fixed.
Do you know any way that the manual information anchors the primary key of the table?
3 Replies
Depends on which technique you use for SQL query. If that's Power Query SQL connector, the workaround is return Power Query result as table first time, add manual column to it, Power Query this table again, merge with source on unique ID and return this result instead of initial one. All shall be done within same query, not as separate ones.
Thank you SergeiBaklan, unfortunately, I don't have the skills to do what you suggest. Do you have any documentation I can use as a guide?
Regards,
Please check this blog Self Referencing Tables in Power Query - Excelerator BI
