Transform Validation with multiple columns

[Former Member]

Hi,

Is there any way to include multiple columns validation in validation transform?

I tried to use custom condition: ifthenelse(inputfield1 = 61 and inputfield2 = 'S',true, false) but it doesn't work, so I ended up doing the same on a previous query transform, mapping it to a field with 1 or Null and then using this new filed as unique column validation, but wanted to know if it could be handled by the column validation alone.

Cheers

[Former Member · Accepted solution]

Hi,

You can include multiple columns in your validation.

Create the validation for Input Field1 with custom condition as below,

ifthenelse(Inputfiled1 = 61 and Inputfield = 'S','TRUE','FALSE') = 'TRUE'

which ever doesn't satisfy the above rule it will go to invalid tables.

Regards,

Senthil

[krishnamohan_corp9]

Hi Pedro,

Column validation can be done only for single column.

Please refer the below guide page 799.

http://help.sap.com/businessobject/product_guides/sbods42/en/ds_42_reference_en.pdf

you can use the decode function/if then else function to achieve it.

Close the thread if your question has been answered.

Thanks

Krishna Mohan