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
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Greg_Deckler

 

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

 

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
8 years ago

Anonymous - We don't need actual data, just sample data that is representative of your data. Do you really have just a single column in your data tables? Is it at least in the same order for both? If it is, you might be able to add an Index column on import for both and relate them that way via the Index columns.

 

The issue I think that we are all struggling with is that you want to concatenate two values from two separate tables but I do not see anything in any of your posts that shows how these tables are related to one another. That is going to be a requirement for any solution, a way to say that "Apple" is related to "123456". If there is no way to relate these two things programmatically I don't see a solution unless you would manually create a relationship table but at that point, you would already have the solution in manually creating that table.