MAPPING

[Former Member]

hi,

i hav 3 elements at my source side A,B,C....if A does not equals to "2" or "64" then ihav to pass system date,no need to check conditions,,,,if A does equals to "2" or "64" ..then i hav 2 check the following conditions..the condition is if B equals to"203" or"204" then pass first 8 digits of C otherwise pass source value into target value.

.------->do ineed 2 create udf for it?

regards,

keerthi

[former_member181955]

Keerthi,

Check the occurence of source fields A,B,C if it is more than one better to write a UDF with context.

Thanks

Prasad Nemalikanti

[Former Member]

Hi Keerthi,

As suggested bu Varun / Ramma, this can be achieved using ya " if then else"..but would be good idea to write your own UDF..because you will get better control over data. Also it will reduced complexity.

Would be easy for debugging as well..

Nilesh

[Former Member]

ya can be done using if then else

Regards,

Rama Krishna

[former_member192892]

1st check,

A equals "2" or A equals "64" using text equals, and boolean or and pass it to if condition

[former_member192892]

This i think can be achieved by using if else function