Originally posted by: gunturi_s
Hello ,
I think this topic is quite common question which might have been faced by every developer regarding functions. when we write a function with two inputs the output is always doubled by the no.of occurrences in each input. I am looking for some help on how to avoid that.
My inputs are as below which are multi occurrence groups
Input 1: A1, A2,A3,A4
Input 2: B1, B2,A3,B4
The function is written to replace A2 with the value of B2 from the row which has same values in A3 .
the current function rule is written as
=Function_replace(input1, Extract(input2, index(input1)=index(input2))
and inside the function the A2 rule is written as A2=Extract(B2, A3=B3)
Lets say input1 and input 2 have 2 rows each and I am expecting the output from the function as 2 rows only but with A2 field replaced. Currently I am receiving the output as 4 rows . Any help is appreciated.
#IBM-Websphere-Transformation-Extender#IBMSterlingTransformationExtender#DataExchange