Result in where clause

[Karuetl]

I have a flow as below 

source-->httprequest--> tExtractXMLField --> tFilterRow-->file(listofvalues)

I want the out put of the tfilterrow to be in the where clause of the query 

example select * from table where col in ( list of values)

[vboppudi]

HI,

Please try the following process. You have two records from XML extract and using tAggregate list function concatenate two values in single record. the using tJavarow assign that value to context variable. tJava used to display context value. tOracleInput used context value and return output.

Regards,