topic Re: Merge two output of tmap same shema in Talend Studio

Merge two output of tmap same shema

Anonymous — Fri, 28 Jul 2017 12:25:09 GMT

Hi everybody

I want to merge two output of tmap in one output and then i want to replicate my out put

screenshots explain my subject

best regards

Re: Merge two output of tmap same shema

TRF — Fri, 28 Jul 2017 12:39:21 GMT

You need to start a new subjob to merge the flows (using tMap or tUnite) as you cannot do it int the same subjob where the initial flow has been splitted.

Re: Merge two output of tmap same shema

Anonymous — Fri, 28 Jul 2017 14:59:34 GMT

thank you for reply, can you explain more plz, with screenshots

Re: Merge two output of tmap same shema

TRF — Fri, 28 Jul 2017 15:10:42 GMT

Here is what it should look like:

Flows from tMap are connected each to a dedicated tHashOutput.

OnSubjobOk, the content of the 2 tHash is merged using tUnite (via tHashInput to get the content).

To activate tHash component, go to File > Edit Projetc properties > Designer > Pelette Settings and push the Technical folder to the Show column if it is not yet.

Re: Merge two output of tmap same shema

vapukov — Tue, 01 Aug 2017 04:05:43 GMT

in additional to @TRF - could be little slower, but less memory usage, You can change tHash to CSV files

tHash - excellent for small data-sets, but could eat all memory unpredictable

CSV work very fast compare to most of database outputs

Re: Merge two output of tmap same shema

ThWabi — Tue, 01 Aug 2017 07:40:30 GMT

Hi developper_webio,

if you do not need to further process the two outputs separately, may I suggest creating just one tMap output with the following filter condition:

( row1.size.equals(0) && row1.CF.equals("VFG") ) || ( !row1.size.equals(0) && row1.CF.equals("RFP") )

Best regards,

Thomas

Re: Merge two output of tmap same shema

Anonymous — Tue, 01 Aug 2017 09:05:35 GMT

Hello,

Please take a look at this article about:https://community.talend.com/t5/Troubleshooting-Development/Can-I-create-a-Job-with-multiple-paths-from-a-single-source-to/ta-p/21653

Best regards

Sabrina