How to horizontally join tables

[Anonymous]

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? 

[akumar2301 · Accepted solution]

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

[Anonymous]

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

[akumar2301]

Can you please attach tMap screenshot

[Anonymous]

somehow it worked. Thanks for your inputs