How can i extract data from multiple matching condition?

[RInt1680691721]

Dear team,

I am trying to filter data using below condition in tMap so could you please help me?

Column1.contains("_A") &&

Column1

.contains("B_") &&

Column1

.contains("CD_") &&

Column1.

contains("_DC")

Nothing is extracting from database when i use above condition in tMap.

Kr,

R

[jlolling_kloeckner]

Your expression expects all conditions must be true. Are you sure you need all of the as true?

For me it looks like more you need an OR instead of an AND.

Column1.contains("_A") ||

Column1.contains("B_") ||

Column1.contains("CD_") ||

Column1.contains("_DC")

[RInt1680691721]

Thanks for reply

Yes, I expects all conditions must be true.

Any other way i can handle using routines?

[jlolling_kloeckner]

You can of course cresate a routine. This would provide the advantage you can test it well. Actually your code is correct and I cannot see why it does not work. You should provide us the jab designe as screenshot and some sample data.

[RInt1680691721]

It just a simple extraction of data from source, not equal to is working for me but without not equal not working

[Anonymous]

You mentioned "Nothing is extracting from database when i use above condition in tMap." If you use this expression on tMap, it only filter the rows from the input data flow before tMap, if no records are extracted from database, you should check your query.