SOLVED

Column not appending correctly

Deleted
Not applicable

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
best response
Solution

@Deleted , 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:

@Deleted , 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.

1 best response

Accepted Solutions
best response
Solution

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

View solution in original post