Unite multiples flow into one flow from tFileInputPositional

[Anonymous]

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!

[manodwhb]

@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.

[Anonymous]

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

flow2

flow2

flow3

or

flow2

flow3

flow2

or 

flow2

flow2

flow2

flow3

Only the last flow2, flow3 goes together

[David_Beaty]

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->

[Anonymous]

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!