Forum Discussion
Concatenation from two different tables - Explanation Needed
Community ChampionCan you post a short sample of your data? What I am wondering is if there is a common key between your tables. In the Query Editor, on the Home tab all the way to the right is the "Merge Queries" link. This allows you to merge two queries as you are suggesting as long as you have some kind of common key between them.
I apprecitate that, however I don't think I want to merge the queries.
Do we agree that a CONCATENATE function is not available when there are two tables?
Thanks,
- Greg_Deckler
Might be able to use it if you use RELATED or RELATEDTABLE. You could also look at using LOOKUPVALUE function. I'm still not clear what you are trying to accomplish. If you would post sample data and sample output that would greatly assist.
Wish I could post a sample dataset...I cannot.
I am siply trying to combine the the value from one column in Table A with a column in Table B.
i.e.
Table A = Apple
Table B = 123456
New column equals "Apple 123456"
Appreciate your interest and advice.
Thanks,
Adam
