Validation Transform in BODS

[Former Member]

Hi Everyone,

I have created a job and  was trying to implement a validation rule the Condition is I have different Account Groups but for a particular Account Group if the Company Code is Null then the record must go to the fail .

As I was trying to know the custom function for this Scenario to write in the validation transform .

Thanks.

[Former Member]

its pretty common requirement , build a look up table with account group and company code.

input account group=account group in lookup

get company code

if this this company code is NULL send to fail validation

[former_member186894]

Hi, You can use below settings. Choose Company Code column in Column Validation.

When you connect to target table make sure you choose Send to Pass option.

Thanks,

Imran