Table has multiple columns. verifying currency by country using twebserviceinput. I tried joining the output from twebserviceinput with the source column in tmap but not working.
table -> tFlowToIterate - this part read row by row and store all row in globalMap, with names "rowxxx.columnname", where rowxxx - name under line between table and tFlowToIterate
tFlowToIterate -> tFixedFlowInput. in tFixedFlowInput you define schema - what you want to path forward. For example Curency, and in value put (String)globalMap.get("rowxxx.columnname") (String - just an example)
connect tFixedFlowInput ->tMap -> twebServiceInput, in tMap you prepare structure accepted by your webservice - XML or JSON or just a text in proper column
Thanks, for the quick reply. Looks like you can not connect tmap to twebserviceinput but can connect to twebservice. is there a way you can join the source columns to the output column of the twebserviceinput component?
Source has 4 input column (f1,f2,f3,f4) .Only 2 required columns are passed to tflowiterate and the output column from tflowiterate is then passed to twebserviceinput.
f1----->tflowiterate
f2---> tflowiterate
output column from tflowiterate passed to twebserviceinput. Output column from twebserviceinput needs to be joined back to column f3 and f4. before loading the target table.
I have attached the design and the values passed in each component. In twebservice component in the output schema add the source column you want to pass to the target. In tFixedflow pass the global variables. under the Value press ctrl space and slect the global variable with the column name you want to pass to the twebservice input.
In tJavaRow please note the last column is pulled from row2 link. After tJavarow pass you pass the value to tgt.
