topic Re: Unite multiples flow into one flow from tFileInputPositional in Talend Studio

Unite multiples flow into one flow from tFileInputPositional

Anonymous — Mon, 21 Jan 2019 12:09:47 GMT

Hi,

I have multiples tFileInputPositional where each one is a different record set which its own path. I have this issue: I need to unite flow2 and flow3 as it if where a single flow. So, right now I have:

flow1

flow2

flow3

flow4

and I want:

flow1

myFlow = flow2 + flow3

flow4.

So, myFlow must contain flow2 and flow3 paths.

I was trying to connect tFileInputPositional3 to tMap2, but I cannot do that. Does anyone have any idea?

Thank you in advance!

Re: Unite multiples flow into one flow from tFileInputPositional

manodwhb — Mon, 21 Jan 2019 12:16:54 GMT

@Emanuele89 ,since you cannot connect from the same origin,since what i will suggest to you load into tHashOutput and by using on subjob ok read those data what you have loaded to tHashInput and use tUnite to merge both flows data in to single.

Re: Unite multiples flow into one flow from tFileInputPositional

Anonymous — Mon, 21 Jan 2019 16:30:52 GMT

No, I doesn't work this way. Is not that simple. I forgot to say that the structure could be like this:

flow2

flow3

flow2

flow3

flow2

flow3

Only the last flow2, flow3 goes together

Re: Unite multiples flow into one flow from tFileInputPositional

David_Beaty — Mon, 21 Jan 2019 17:01:45 GMT

You must make sure, when using the tUnite component that, in your case, flows 2 & 3 are exactly the same schema - so you should use the same Repository Schema.

If they do differ slightly, use 2 tJavaRow or tMap components to make them the same:

flow2->tjavarow->

tUnite -> flows2 & 3

flow3->tjavarow->

Re: Unite multiples flow into one flow from tFileInputPositional

Anonymous — Wed, 23 Jan 2019 10:49:25 GMT

If I use tMap, how can I make the same schema? Do I have to add flow2 columuns and then flow3 columns? Do I need two different tMap or only one? Some columns have the same name, how can I manage it? Could you give me an example, please?

Thank you in advance!