Forum Discussion
Concatenation from two different tables - Explanation Needed
Community ChampionI believe that you want to create a Merge or Append query. Kind of sounds like a Merge query is what you are describing.
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?
- Greg_Deckler
Can 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.