Forum Discussion
Concatenation from two different tables - Explanation Needed
Possibly, though I am not sure how to do this?
I am siply trying to create a third column in my data that combines the Product with the ID.
Becasue they live in two different tables, the Concatenate function doesn't work (but would if both data elements were in the same table).
Recommendations?
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