using NOT LIKE in transformation

today · Post by **today** » Mon Jul 27, 2009 7:08 pm

Hi,

When I am using NOT LIKE in a transformation, DS is throwing error : error compiling sub routine for stage.

If there any other function for accomplish following task:

IF DRS_PS_D_PRJ.PROJECT_ID LIKE '8%' Then 'Y' Else 'N'

Thanks

ray.wurlod · Post by **ray.wurlod** » Mon Jul 27, 2009 7:25 pm

NOT LIKE is not supported. That's SQL. You can use NOT LIKE in a Filter stage.

In a Transformer stage, you must build an expression using Not() function and Matches operator. Or you can test the first character of the string as an explicit character value.

keshav0307 · Post by **keshav0307** » Mon Jul 27, 2009 7:54 pm

IF DRS_PS_D_PRJ.PROJECT_ID LIKE '8%' Then 'Y' Else 'N'
can be
IF LEFT(DRS_PS_D_PRJ.PROJECT_ID,1)='8' Then 'Y' Else 'N'

-----------

IF DRS_PS_D_PRJ.PROJECT_ID NOT LIKE '8%' Then 'Y' Else 'N'
can be
IF LEFT(DRS_PS_D_PRJ.PROJECT_ID,1)<>'8' Then 'Y' Else 'N'

today · Post by **today** » Tue Jul 28, 2009 8:27 am

Thanks Keshav,

It worked liked a charm

Really appreciate your help.