Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, Friends:
I have one-to-many tables to load, but it only get parent table. For example,
table order:
ORDERID NAME
---------------------------
1 p100
2 p200
table operation
ID ORDERID NAME
-------------------------------
1 1 opx
2 1 opy
3 1 opz
4 2 opi
5 2 opj
I want to use table order as main input and lookup the associated table operation, so I can get all operations. It looks like run query,
select a.*, b.* from order a inner join operation b on a.orderid=b.orderid
How can I do this?
Thanks,
Vincent
I have one-to-many tables to load, but it only get parent table. For example,
table order:
ORDERID NAME
---------------------------
1 p100
2 p200
table operation
ID ORDERID NAME
-------------------------------
1 1 opx
2 1 opy
3 1 opz
4 2 opi
5 2 opj
I want to use table order as main input and lookup the associated table operation, so I can get all operations. It looks like run query,
select a.*, b.* from order a inner join operation b on a.orderid=b.orderid
How can I do this?
Thanks,
Vincent
Hi Vinshu,
in your first post you wrote something like "I want to use order as main input and want to lookup the operation...". This would mean:
ORDERID NAME NAME (OP)
--------------------------------------------
1 p100 opx
1 p100 opy
1 p100 opz
2 p200 opi
2 p200 opj
Looks a bit like what you have just posted 😉 But is there a reason why you don't use the operation table as main and only lookup the name from the order table? Cause this would be exactly what you posted as your desired output...
Concerning your question with the duplicate data (i guess you mean that e.g. ORDERID 1 is opx, opy, and opz?): Have you tried to set up your table like in my screenshot from the linked post (with one table less of course) and does the result really not look as you want it to do?
Then please show the result you get and your tMap setup so we can see what may be the problem.
Regards,
Theo
in your first post you wrote something like "I want to use order as main input and want to lookup the operation...". This would mean:
ORDERID NAME NAME (OP)
--------------------------------------------
1 p100 opx
1 p100 opy
1 p100 opz
2 p200 opi
2 p200 opj
Looks a bit like what you have just posted 😉 But is there a reason why you don't use the operation table as main and only lookup the name from the order table? Cause this would be exactly what you posted as your desired output...
Concerning your question with the duplicate data (i guess you mean that e.g. ORDERID 1 is opx, opy, and opz?): Have you tried to set up your table like in my screenshot from the linked post (with one table less of course) and does the result really not look as you want it to do?
Then please show the result you get and your tMap setup so we can see what may be the problem.
Regards,
Theo
Hi,
In the Mapper (tMap component), you have the capability to join table_operation and table_order (ORDERID will be the KEY).
You have also some join options (InnerJoin or OutterJoin, Unique match, First match, Last match ,All matches).
Please refer to the Talend user guide ( User guide) and Talend demo project (embedded into the Studio, in the login Page, push DEMOS button to import this project).
Best regards.
In the Mapper (tMap component), you have the capability to join table_operation and table_order (ORDERID will be the KEY).
You have also some join options (InnerJoin or OutterJoin, Unique match, First match, Last match ,All matches).
Please refer to the Talend user guide ( User guide) and Talend demo project (embedded into the Studio, in the login Page, push DEMOS button to import this project).
Best regards.