Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Concatenation from two different tables - Explanation Needed

Using the New Column function, I am attempting to concatenate a column from one table with a column in another table.   Depending on which table I create the column, it either recognizes one data e...
Need Help
Show and Tell
Tips and Tricks
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
8 years ago

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.

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Greg_Deckler

 

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,