topic Re: [resolved] Activate Expression filter multiple clause in Talend Studio

[resolved] Activate Expression filter multiple clause

Anonymous — Mon, 09 Jan 2017 20:40:05 GMT

Hi,
I have two requirements where I have to reject rows. The first one is working great but I do not know how to add the second requirement. The two requirements are totally variant from each other and need to be dealt separately. My second requirement is to throw out the Reid, John and Cindy with the date 3/8/2015 into the tpostgresqloutput_2 like I am doing with the unknown values from the Builder column. I want to know if I can apply two if statements in the same expression filter affecting totally different rows. I have added a comma after the first requirement to show that the two requirements are two different if clauses.
!"unknown".equals(row1.Builder) ,
!"Reid, John & Cindy".equals(row1.Last_Name_First_Name) && row1.Actual_Sale_Date=="3/8/2015"

Re: [resolved] Activate Expression filter multiple clause

Anonymous — Tue, 10 Jan 2017 08:55:43 GMT

Hi
It is impossible to add different filter conditions in the same field. As a workaround, duplicate the input data and do the filter two times, eg:
...tfileinputDelimited--main..tReplicated--main--tMap1(do filter1)--
--main--tMap2(do filter2)--
Regards
Shong

Re: [resolved] Activate Expression filter multiple clause

Anonymous — Tue, 10 Jan 2017 20:48:46 GMT

I do not understand Sabrina, do you I need to add two more tPostgresqloutput since I have to add one more tMap? Please provide me with an image which can guide me. I need to add two filters overall.

Re: [resolved] Activate Expression filter multiple clause

Anonymous — Wed, 11 Jan 2017 01:56:55 GMT

Yes, you need to add different tPostgresqlOutput components for each filter operation.
...tfileinputDelimited--main..tReplicated--main--tMap1(do filter1)--out1--tPostgresqloutput1
--reject1--tPostgresqloutput2
--main--tMap2(do filter2)--out2--tPostgresqloutput3
--reject2--tPostgresqloutput4

Re: [resolved] Activate Expression filter multiple clause

Anonymous — Wed, 11 Jan 2017 03:48:39 GMT

Thanks Sabrina,
Should I also name the second set of tpostgreSQLoutputs the same as the first set?
e.g.
treplicate-------->tmap1------>tpostgreSQLoutput (mytable)
tmap1------>tpostgreSQLoutput (rejectedtable)
----------------------tmap2-------->tpostgreSQLoutput(mytable)
tmap2-------->tpostgreSQLoutput (rejectedtable)
My second filter is
!'Reid,John & Cindy'.equals(row1.Last_Name_First_Name) && row1.Actual_Sale_Date == '03/08/2015'
this line threw out an error:
string and date operand error.

Re: [resolved] Activate Expression filter multiple clause

Anonymous — Fri, 13 Jan 2017 06:38:48 GMT

Thanks Sabrina,
Should I also name the second set of tpostgreSQLoutputs the same as the first set?

Sorry, I don't understand your question. BTW, I am Shong, not Sabrina.

this line threw out an error:
string and date operand error.

What's data type of Actual_Sale_Date column?
If String, the expression should be:
(!"Reid,John & Cindy".equals(row1.Last_Name_First_Name)) && row1.Actual_Sale_Date.equals("03/08/2015")
If Date:
(!"Reid,John & Cindy".equals(row1.Last_Name_First_Name)) && TalendDate.formatDate("dd/MM/yyyy", row1.Actual_Sale_Date ).equals("03/08/2015")

Regards
Shong

Re: [resolved] Activate Expression filter multiple clause

Anonymous — Fri, 13 Jan 2017 14:15:28 GMT

Thanks Shong not Sabrina!!!!