Using Not Like in a Filter/transform stag

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
ANDOPEPENANDO
Participant
Posts: 5
Joined: Fri Feb 17, 2017 8:48 am
Location: Jalisco

Using Not Like in a Filter/transform stag

Post by ANDOPEPENANDO »

Hi forum.
If exists the Not Like function in DS Used thru Filter o transformer stage
Example; columnA Not Like '%test%' or columnB not like '%bademail.com%'

Or probably any other stage from data quality

Thanks in advance
JRodriguez
Premium Member
Premium Member
Posts: 425
Joined: Sat Nov 19, 2005 9:26 am
Location: New York City
Contact:

Post by JRodriguez »

The Index() funtion should serve the purpose...try it in a transformer as below

If Index(inputColumnA,'test',1) <= 0 and Index(inputColumnB,'badrmail.com',1) <=0 Then....
Julio Rodriguez
ETL Developer by choice

"Sure we have lots of reasons for being rude - But no excuses
Post Reply