Mapping

[Former Member]

Hi,

Using Fix values function we can pass some values like

if field1 = a then field1 =1

if field1= b then field1 =2

if field1 = c then field1 =3

if field1= d then field1 =4

do we have a mapping function to do:-

if field1 =a and field 1= 1 then field1 =a1

if field1=b and field1=2 then field1 =b2

Jeff

[Former Member]

Jeff,

<i><b>if field1 =a and field 1= 1 then field1 =a1</b></i>

How would your input have two values 'a' and '1' for one input?

---Satish

[Former Member]

Hi,

Using Fixvalues we can do it for one value

as i mentioned in the post.

but now my issue

there is one input value but it needs to check with two conditions to procude target

example if field1 = a and field 1= b then field 1=c

for same field1 ther ecan be multiple conditions

Jeff

[Former Member]

hey

write a advanced UDF for this.

thanx

ahmad

[Former Member]

do we have standard function ?

or sample code for UDF

[Former Member]

Hey

did u try using two If-Else conditions?

i guess u shud be able to achieve this through two If-Else conditions one after another.if that works u dont have to write any UDF.

thanx

ahmad

[henrique_pinto]

Jeff,

how can field1 assume different values?

Did you mean, by any chance, to perform an 'OR' check, instead of an 'AND' one?

If that's wat you meant, then you can't do it by standard, but you could do a workaround with UDF or even with multiple FixValues tables and simple logic. UDF would be simpler though.

Regards,

Henrique.

[Former Member]

Hi,

can someone give me sample code for UDF?

my issue is i need to use AND condition

input value should be checked against two values to producce target value.

for same input value you can do multiple condition checks to produce different target values.

Jeff

[henrique_pinto]

Jeff,

for your field to assume multiple values, it needs to accept multiple entries (you'll have more than 1 field1 fields in your source message). Is that your case?

If not, then your request doesn't make any sense.

Regards,

Henrique.