topic How to horizontally join tables in Talend Studio

How to horizontally join tables

Anonymous — Sat, 08 Feb 2020 03:45:15 GMT

I have a large table with 200 columns. I am fetching it by breaking it down to sub-tables of 50 columns each. Now I want to merge data from those sub-tables into a single file. How do it do it? I tried tMap but it is taking Cartesian product of sub-tables data. Is there a way to horizontally merge the tables?

Re: How to horizontally join tables

akumar2301 — Sat, 08 Feb 2020 10:40:31 GMT

Did you face problem with 200 columns? Ideally it should work.

You need to fetch key columns for each split.

Then in Map do innerjoin between tables

Re: How to horizontally join tables

Anonymous — Mon, 10 Feb 2020 18:18:46 GMT

Its not working. Actually its the SAP Table and the SAP component is not fetching all the columns in one go.

Re: How to horizontally join tables

akumar2301 — Mon, 10 Feb 2020 19:29:10 GMT

Can you please attach tMap screenshot

Re: How to horizontally join tables

Anonymous — Fri, 21 Feb 2020 02:05:16 GMT

somehow it worked. Thanks for your inputs