I have a set of IPs that I am querying from a database and for each IP I am trying to call a Web service to lookup values.
For one row the data flow works fine. But for multiple rows, I get same lookup values repeated for all the input rows. I tried a few things based on another post but didn’t work. Appreciate any help on how to make this work.
I have attached a couple of screenshots of the dataflow.
Thanks.
Ram
rnatarajan (BOB member since 2009-10-13)
add a Row_Gen transform and set the from clause of Query_IP as Row_Gen, remove SQL from the from clause for Query_IP
Keep the from clause of GetIPGeo schema as SQL only
manoj_d (BOB member since 2009-01-02)
Thanks for your quick response manoj. But it is still giving only one row as output although it is reading 344 rows. I have attached the screen snapshots after the changes.
rnatarajan (BOB member since 2009-10-13)
check what happens if you keep the from of both the schema as Row_Gen
manoj_d (BOB member since 2009-01-02)
Actually I need the SQL in from because the values from the query need to be passed to the subsequent transforms. I get a runtime error if I don’t have SQL in from. I added the Row_gen also in the from. But still same result.
rnatarajan (BOB member since 2009-10-13)
sorry, keep the from clause of Query_IP as SQL and GetIPGeo as Row_Gen
manoj_d (BOB member since 2009-01-02)
That worked!! Thank you so much! 
rnatarajan (BOB member since 2009-10-13)