merge query columns coming up as blank

[kendall]

Hello,

When I merge queries, the columns for the merged queries come up as blank or null. What might be causing this? Thanks. 

[kendall]

Thanks Migasuke, figured it out. You are correct: the data types did not match.

[Migasuke]

Hi @kendall ,

If you merge two queries and you receive blank there are usually two reasons:
1. There is no match between tables.
2. Data itself contains blanks.

Best troubleshooting is:

1. Check if you selected proper columns for the merge.
2. Check if the data types are the same in both tables.
3. Check if the values are really matching, for example EUR vs eur. , this will not merge properly.

Let me know if it helps.