topic Re: Joining tables with different column lengths in Discussions

Joining tables with different column lengths

ENTHU — Wed, 16 May 2018 02:42:07 GMT

Hi,

I have 2 tables say A and B. Table has a number columns including name.Table A has 10 names.Table B is a referencelist which has 1000 names and corresponding ages. Is there a way to join the 2 tables so that the new joined table has only 10 names from Table A and respective ages from Table B?

when I tried this , got an error saying columns do not match.

TIA

Re: Joining tables with different column lengths

txnelson — Wed, 16 May 2018 03:14:30 GMT

Tables==>Join

will do exactly this. Just select the columns you want to match on, and then select to "Include non-matches" for the main table(your table with 10 names). The resulting table will have only your 10 names.

Re: Joining tables with different column lengths

ENTHU — Wed, 16 May 2018 03:38:59 GMT

This works! Thanks for the quick reply.

But the joined table now has 2 columns named as age.Is there a way to retain only one?

Re: Joining tables with different column lengths

txnelson — Wed, 16 May 2018 03:46:50 GMT

If you look at my last response, you will see that one of the selections I made on the Dialog for the Join Platform, is called "Merge same name columns". This will match names.

If you open up the Tables==>Join dialog, you can click on the "Help" button and it will display information about all of the selections and settings availabel to the platform. You need to familiarize yourself with the Help environment. It is a very quick and easy way to learn all about any of the platforms.

Re: Joining tables with different column lengths

ENTHU — Wed, 16 May 2018 03:59:58 GMT

Thanks. I had made right selections.But the problem was one table had column name Age and another age.