Problem in UDF

[former_member207622]

Hi Folks ,

I have a requrement in which I have a country and corresponding cost centre is cominig from one input file

and another country is coming in second input file .

Now I have to compare if country1 == country2 then pass the corresponding cost centre to the output

for eg

country cost centre

argentina BA0004TOO26 -

---

FIRST INPUT FILE

IF argentina( file 2) == argentina then cost centre should have a value BA0004TOO26

hope this is clear now

please help how to achieve this

Thnx

Ninad

[prateek]

BPM would allow you to merge the two files. These two files should use multimapping inside the Transformation step. In this step, you will have both the files, so using simple graphical mapping or UDF, you may include the conditions.

Regards,

Prateek

[Shabarish_Nair]

use multimapping (in your case 2:1)

thus here both the input fields will be available for your UDF and u can easily do the compare.