Unite multiples flow into one flow from tFileInputPositional

Seven Stars

Unite multiples flow into one flow from tFileInputPositional

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!

 

 

Forteen Stars

Re: Unite multiples flow into one flow from tFileInputPositional

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

Manohar B
Don't forget to give kudos/accept the solution when a replay is helpful.
Seven Stars

Re: Unite multiples flow into one flow from tFileInputPositional

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

Nine Stars

Re: Unite multiples flow into one flow from tFileInputPositional

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

Regards David
Dont forget to give Kudos when an answer is helpful or mark the answer as the solution.
Seven Stars

Re: Unite multiples flow into one flow from tFileInputPositional

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!

Calling Talend Open Studio Users

The first 100 community members completing the Open Studio survey win a $10 gift voucher.

Start the survey

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

APIs for Dummies

View this on-demand webinar about APIs....

Watch Now