SOLVED
Home

Column not appending correctly

%3CLINGO-SUB%20id%3D%22lingo-sub-770462%22%20slang%3D%22en-US%22%3EColumn%20not%20appending%20correctly%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-770462%22%20slang%3D%22en-US%22%3E%3CP%3EWhen%20appending%20two%20of%20the%20queries%20together%20one%20of%20the%20columns%20separates%20and%20becomes%20two%20separate%20columns.%20(%20see%20picture)%20for%20the%20life%20of%20me%20I%20can't%20figure%20out%20why%20this%20is%20happening.%20Please%20help!%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20style%3D%22width%3A%20486px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F124213i9966CCE3B284BB18%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%221.PNG%22%20title%3D%221.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20style%3D%22width%3A%20486px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F124214i21E9AE887D833C2F%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%222.PNG%22%20title%3D%222.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20style%3D%22width%3A%20636px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F124215i122C7061A2F98138%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%223.PNG%22%20title%3D%223.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-770462%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%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-770496%22%20slang%3D%22en-US%22%3ERe%3A%20Column%20not%20appending%20correctly%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-770496%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F380833%22%20target%3D%22_blank%22%3E%40Fernandez6%3C%2FA%3E%26nbsp%3B%2C%20most%20probably%20you%20have%20%22Project%20Risk%20Number%20%22%20with%20extra%20space%20at%20the%20end%2C%20and%26nbsp%3B%22Project%20Risk%20Number%22%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-770500%22%20slang%3D%22en-US%22%3ERe%3A%20Column%20not%20appending%20correctly%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-770500%22%20slang%3D%22en-US%22%3ESounds%20silly%20but%20make%20sure%20that%20both%20table%20columns%20are%20labeled%20exactly%20the%20same%20(i.e.%20no%20spaces%20before%20or%20after).%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-770501%22%20slang%3D%22en-US%22%3ERe%3A%20Column%20not%20appending%20correctly%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-770501%22%20slang%3D%22en-US%22%3E%3CBLOCKQUOTE%3E%3CHR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3Bwrote%3A%3CBR%20%2F%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F380833%22%20target%3D%22_blank%22%3E%40Fernandez6%3C%2FA%3E%26nbsp%3B%2C%20most%20probably%20you%20have%20%22Project%20Risk%20Number%20%22%20with%20extra%20space%20at%20the%20end%2C%20and%26nbsp%3B%22Project%20Risk%20Number%22%3C%2FP%3E%3CHR%20%2F%3E%3C%2FBLOCKQUOTE%3E%3CP%3E%3CBR%20%2F%3EI%20did%20not%20see%20this%20response%20in%20time!%20That%20would%20be%20my%20guess%20as%20well.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-770522%22%20slang%3D%22en-US%22%3ERe%3A%20Column%20not%20appending%20correctly%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-770522%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3EAn%20hour%20of%20debugging%20for%20such%20a%26nbsp%3B%20simple%20solution!%3C%2FP%3E%3CP%3EThank%20you%20very%20much.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Fernandez6
New Contributor

When appending two of the queries together one of the columns separates and becomes two separate columns. ( see picture) for the life of me I can't figure out why this is happening. Please help!

1.PNG

 

2.PNG

 

3.PNG

 

4 Replies
Solution

@Fernandez6 , most probably you have "Project Risk Number " with extra space at the end, and "Project Risk Number"

Sounds silly but make sure that both table columns are labeled exactly the same (i.e. no spaces before or after).

@Sergei Baklan wrote:

@Fernandez6 , most probably you have "Project Risk Number " with extra space at the end, and "Project Risk Number"



I did not see this response in time! That would be my guess as well.

@Sergei Baklan  

An hour of debugging for such a  simple solution!

Thank you very much.

Related Conversations