topic Re: tFilterrow Advanced condition in Talend Studio

tFilterrow Advanced condition

ishchopra — Tue, 12 Sep 2017 13:37:53 GMT

Hello there,

I am trying to put two conditions between or but it is not giving expected results. please help

Query:

!(input_row.Status.equals(null)) && !(input_row.Status.equals("")) || ----- This condition works but if i put && instead of or then it throw nullpointer error

(input_row.Status.equals("Opt-out") && input_row.SF_ID.equals(""))

I am enclosing a screenshot, the highlighted row should not appear in the results

thanks in advance

Re: tFilterrow Advanced condition

Anonymous — Tue, 12 Sep 2017 13:42:24 GMT

Hello,

can you try with :

(input_row.Status != null) && !(input_row.Status.equals("")) || (input_row.Status.equals("Opt-out") && input_row.SF_ID.equals(""))

good luck

SGV

Re: tFilterrow Advanced condition

ishchopra — Tue, 12 Sep 2017 13:51:31 GMT

Hey SGV,

thanks for the reply but it is still the same

Re: tFilterrow Advanced condition

Anonymous — Tue, 12 Sep 2017 13:52:48 GMT

Oh NOOO

i get it ! You want to print if :

( (input_row.Status != null ) && (! input_row.Status.isEmpty()) && ( (input_row.Status.equals("Opt-out") && !(input_row.SF_ID.isEmpty()) ) )

I think, it's what you want .

Re: tFilterrow Advanced condition

TRF — Tue, 12 Sep 2017 13:54:47 GMT

please clarify the expected expression:
- A || B && C
- (A || B) && C
- ...

Re: tFilterrow Advanced condition

ishchopra — Tue, 12 Sep 2017 13:59:56 GMT

sgv,

here is the error, i tried but then i get null pointer, thought of send it back to expert

Execution failed : Job compile errors
At least job "VALLDATA_FILE_CONSENT" has a compile errors, please fix and export again.
Error Line: 2962
Detail Message: Syntax error, insert ")" to complete ArgumentList
There may be some other errors caused by JVM compatibility. Make sure your JVM setup is similar to the studio.
Job VALLDATA_FILE_CONSENT ended at 13:59 12/09/2017. [exit code=0]

Re: tFilterrow Advanced condition

ishchopra — Tue, 12 Sep 2017 14:05:55 GMT

Fred,

Is that a Riddle? sorry didn't understand

Re: tFilterrow Advanced condition

ishchopra — Tue, 12 Sep 2017 14:09:11 GMT

I tried this expression but got error

(!(input_row.Status.equals(null)) && !(input_row.Status.equals("")) ) && (input_row.Status.equals("Opt-out") && input_row.SF_ID.equals(""))

[statistics] connecting to socket on port 3368
[statistics] connected
Exception in component tFilterRow_20
java.lang.NullPointerException
at rspca.valldata_file_consent_0_1.VALLDATA_FILE_CONSENT.tOracleInput_1Process(VALLDATA_FILE_CONSENT.java:3054)
at rspca.valldata_file_consent_0_1.VALLDATA_FILE_CONSENT.runJobInTOS(VALLDATA_FILE_CONSENT.java:3680)
at rspca.valldata_file_consent_0_1.VALLDATA_FILE_CONSENT.main(VALLDATA_FILE_CONSENT.java:3440)
[FATAL]: rspca.valldata_file_consent_0_1.VALLDATA_FILE_CONSENT - tFilterRow_20 null
[statistics] disconnected
Job VALLDATA_FILE_CONSENT ended at 14:08 12/09/2017. [exit code=1]

Re: tFilterrow Advanced condition

Anonymous — Tue, 12 Sep 2017 14:15:52 GMT

(

(input_row.Status != null )

(! input_row.Status.isEmpty())

! ( (input_row.Status.equals("Opt-out")) && (input_row.SF_ID.isEmpty()) )

)

...

Re: tFilterrow Advanced condition

ishchopra — Tue, 12 Sep 2017 14:18:24 GMT

sgv,

i tried the new expression and here is the error

[statistics] connecting to socket on port 4010
[statistics] connected
Exception in component tFilterRow_20
java.lang.NullPointerException
at rspca.valldata_file_consent_0_1.VALLDATA_FILE_CONSENT.tOracleInput_1Process(VALLDATA_FILE_CONSENT.java:3063)
at rspca.valldata_file_consent_0_1.VALLDATA_FILE_CONSENT.runJobInTOS(VALLDATA_FILE_CONSENT.java:3691)
at rspca.valldata_file_consent_0_1.VALLDATA_FILE_CONSENT.main(VALLDATA_FILE_CONSENT.java:3451)
[FATAL]: rspca.valldata_file_consent_0_1.VALLDATA_FILE_CONSENT - tFilterRow_20 null
[statistics] disconnected
Job VALLDATA_FILE_CONSENT ended at 14:17 12/09/2017. [exit code=1]

Re: tFilterrow Advanced condition

Anonymous — Tue, 12 Sep 2017 14:23:18 GMT

(

(input_row.Status != null )

(! input_row.Status.isEmpty())

! ( (input_row.Status.equals("Opt-out")) && (input_row.SF_ID == null) )

! ( (input_row.Status.equals("Opt-out")) && (input_row.SF_ID.isEmpty()) )

)

Re: tFilterrow Advanced condition

ishchopra — Tue, 12 Sep 2017 14:26:05 GMT

sgv,

this worked like a charm.

thanks

Re: tFilterrow Advanced condition

Anonymous — Tue, 12 Sep 2017 14:29:51 GMT

Yessssss !!!!!

Good luck for the continuation,

SGV