Not Equal to Clause in BODS

[Former Member]

Hello Experts -

I need to put this condition in transformation in BODS table1.col 1 Not Equal to table2.col2 .

I am not able to find NOT EQUAL TO clause in BODS. I have used != , But not working.

However equal to (=) is working fine.

Any suggestion how I can use not equal to ? (I want it in Where Tab)

Thanks

R

[former_member182007]

Rohan, please pull/drag your columns into where clause. do not simply write them. and for your condition chk it with " <> " .

hth

thx

deep

[Former Member]

Hi Rohan,

Have you tried using NE ?

Regards

SSS

Edited by: SSS on Jan 25, 2012 2:59 PM

[Former Member]

Hello,

Try using the greater than and less than sign,

some how not able to type the sign's

Regards,

Abhishek