Adding Column in Excel Table with text inputs

%3CLINGO-SUB%20id%3D%22lingo-sub-2944174%22%20slang%3D%22en-US%22%3EAdding%20Column%20in%20Excel%20Table%20with%20text%20inputs%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2944174%22%20slang%3D%22en-US%22%3E%3CP%3EI%20created%20a%20excel%20table%20using%20Power%20Query%20in%20Excel%20and%20added%20a%20column%20to%20within%20excel%20to%20the%20table%20and%20not%20part%20of%20power%20query.%26nbsp%3B%20I%20wanted%20to%20use%20this%20column%20to%20add%20a%20text%20comment.%26nbsp%3B%20However%2C%20anytime%20I%20refresh%20the%20data%20the%20text%20stay%20in%20the%20row%20that%20originated%20from%20but%20the%20data%20associated%20with%20the%20text%20comments%20moves%20to%20a%20new%20row.%26nbsp%3B%20This%20is%20creating%20unrelated%20text%20analysis%20on%20an%20unrelated%20row.%26nbsp%3B%20Is%20there%20a%20way%20to%20keep%20the%20text%20associated%20with%20the%20query%20data%20results%20when%20refreshing%20the%20data%3F%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2944174%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPower%20BI%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2944369%22%20slang%3D%22en-US%22%3ERe%3A%20Adding%20Column%20in%20Excel%20Table%20with%20text%20inputs%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2944369%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1213021%22%20target%3D%22_blank%22%3E%40Eileen3524%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYes%2C%20if%20you%20have%20unique%20ID%20for%20each%20record%20in%20query.%20You%20return%20source%20query%2C%20add%20column%20with%20comments%2C%20query%20such%20table%20again%20and%20merge%20with%20initial%20one.%20All%20shall%20be%20done%20as%20steps%20with%20one%20query%2C%20not%20as%20separate%20ones.%20More%20details%20is%20here%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fexceleratorbi.com.au%2Fself-referencing-tables-power-query%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3ESelf%20Referencing%20Tables%20in%20Power%20Query%20-%20Excelerator%20BI%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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 refresh the data the text stay in the row that originated from but the data associated with the text comments moves to a new row.  This is creating unrelated text analysis on an unrelated row.  Is there a way to keep the text associated with the query data results when refreshing the data?  

3 Replies

@Eileen3524 

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

@Sergei Baklan That worked! Thanks for your help.

@Eileen3524 , you are welcome