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)

[Karuetl]

i dont need three output as below 

need only one 

[statistics] connected
null
null,'222255222'
null,'222255222','54879655'
[statistics] disconnected

[Karuetl]

finally got output but i want to ignore null from it 

(null,'18885806040','260211251892','35351501368')

[Shettydatta]

Awesome Idea!! Works like charm

[Shettydatta]

Hi @Karuetl,

I tried the suggestion from @cterenzi and I got it to work in my tJavaRow so Still not sure what you are doing wrong why don't you output the tAggregateRow to tLogRow and see what is coming out from there. From what I tried I get the solution to work see the screenshot below. 

[Karuetl]

help me how to get the null  out 

[statistics] connected
(null,'3425678','2348056','247907')
[statistics] disconnected

basically xml generated next line character and i use tfilterrow to filter only those records i need and  aggregrate to generate list .. 

[Karuetl]

i tried by checking tlogrow 

here is what i got as below 

[statistics] connected
2345678
4234344
[statistics] disconnected

[Shettydatta]

You have not set the tAggregateRow properties to list read the post above
where it says how to setup the component.

If they are set correctly like in mine you should see 1 row output in
tlogrow

[cterenzi]

In the tAggregateRow settings, check the box that says "Ignore null values"

[Karuetl]

yes i did still same 

[Shettydatta]

Did you set output as list because that is what makes component send one
row out.

And set ignore null values