If then statement in data cleanse

Toad Data Point
1

When putting together an if then statement in the Data cleanse of the results like this:

if((Substr([STOCK_CODE], 1, 1) != '5' AND [ACCOUNT_SEGMENT3] == '700' AND [ACCOUNT_SEGMENT4] == '154041', 'item has wrong account no(inventory account) - Have buyer create change order, cancel this item and add the item back as new item with new account')

This error message is returned.
image

2

Can you let me know what the error means and how it can be corrected? Thanks

3

Just as message says: It appears that you have mismatched set of parens... there's two left parens, but only one right paren. You might want to add a right paren at the end, e.g. something like the following...

IF(
(Substr([STOCK_CODE], 1, 1) != '5'
AND [ACCOUNT_SEGMENT3] == '700'
AND [ACCOUNT_SEGMENT4] == '154041',
'item has wrong account no(inventory account) - Have buyer create change order, cancel this item and add the item back as new item with new account')
)

However, pretty sure that you still need an extra parameter within the IF() construct,
e.g. the "FalseValue"... see below...

image
image856×312 23 KB

4

Thanks, the parenthesis were corrected and it worked.