Page 1 of 1

Using Not Like in a Filter/transform stag

Posted: Fri Feb 17, 2017 3:20 pm
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

Posted: Sat Feb 18, 2017 7:54 pm
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....