topic Re: [resolved] Multiple Rows to single row (on lookup) in Talend Studio

[resolved] Multiple Rows to single row (on lookup)

Anonymous — Fri, 17 Aug 2012 23:22:52 GMT

is there any additional component to achieve this?
mySqlInput--------------->tMap ----------------------------------> tJavaFlex ---------------------------> tWebservice
^ (puts each item in a List) (parameter: List)
| (lookup, join all matches)
|
mySqlInput
when i try to set onComponent ok connection between tjavaflex an webservice, the request only happens for the last main row. When doing normal main connention, each lookup row gets passed to twebservice (not the complete List) Is there any component that passes the output row on condition (only when the list is filled)?

Re: [resolved] Multiple Rows to single row (on lookup)

Anonymous — Sat, 18 Aug 2012 01:03:51 GMT

Hi
In the begining part of tJavaFlex: define a list, eg:
java.util.List list=new java.util.ArrayList();
In the main part of tJavaFlex: add each row to the list, eg:
list.add(row1.columnName);
In the end part of tJavaFlex: put the list to a global variable for use later, eg:
globalMap.put("mylist",list);
in the next subjob, get the list and pass it to tWebservice, the job design looks like:
mySqlInput--------------->tMap ----------------------------------> tJavaFlex
^ (puts each item in a List)
| (lookup, join all matches)
|
mySqlInput
|
onsubjobok
|
tFixedFlowInput--main--tWebservice
on tFixedFlowInput, generate one data flow with one column, let's call it mylist, object type.
key:value
mylist (java.util.Array)globalMap.get("mylist")

Re: [resolved] Multiple Rows to single row (on lookup)

Anonymous — Sat, 18 Aug 2012 01:04:24 GMT

Try a tFlowToIterate before the WebService. No guarantees.

Re: [resolved] Multiple Rows to single row (on lookup)

Anonymous — Sat, 18 Aug 2012 22:26:33 GMT

Hi
In the begining part of tJavaFlex: define a list, eg:
java.util.List list=new java.util.ArrayList();
In the main part of tJavaFlex: add each row to the list, eg:
list.add(row1.columnName);
In the end part of tJavaFlex: put the list to a global variable for use later, eg:
globalMap.put("mylist",list);
in the next subjob, get the list and pass it to tWebservice, the job design looks like:
mySqlInput--------------->tMap ----------------------------------> tJavaFlex
^ (puts each item in a List)
| (lookup, join all matches)
|
mySqlInput
|
onsubjobok
|
tFixedFlowInput--main--tWebservice
on tFixedFlowInput, generate one data flow with one column, let's call it mylist, object type.
key:value
mylist(java.util.Array)globalMap.get("mylist")

shong! talend master! awsome! works as it should, thanks!