Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everybody,
I have to add one row according to data selected from DB. I reading the data from table1(tDBInput3) and inserting to another table. When exist record for supplier in table2(tDBInput4) that i have to add one row with same data but replacing artikleid.
All works fine but i don!t know why I can't unite outputs and after that insert the data to table3.
For example:
INPUT:
table1
order1,supplier1, article1ID
order1,supplier1, article2ID
order2,supplier2, article3ID
table2
supplier1, fakearticleID
OUTPUT:
order1,supplier1, article1ID
order1,supplier1, article2ID
order1,supplier1, fakearticleID
order2,supplier2, article3ID
There is more columns but for the example it is enough
In the studio, I designed it as follows. Have you any idea why i can't connect Uniques to tUnite?
Hello,
Please make sure that creating a subjob structure with multiple paths from a single source to a single target is not allowed in the talend studio.
For more information, please have a look at this community article:https://community.talend.com/t5/Design-and-Development/Can-I-create-a-Job-with-multiple-paths-from-a...
Best regards
Sabrina
@Jaroslav ,since the origin for both is one. you need to have separate flow those you can merge using tUnite.