Hi Experts,
While doing mapping, i came to know that the some part of the code for one of the field should be used for other fields. The mapping is little bit bigger and i dont want to use the same mapping for all the other fields. So is there any way, where we can pass the values to all other fields.
For example, there are three output fields A, B, C. We have done mapping for the 'A' field. We have to use the same logic of 'A' for other fields as input to 'B' and 'C' and those fields values are manipulated based on 'A' field logic. Is there any way how to pass the output values of 'A' to other fields as input?
Thanks,
Srinivas.
Hi Srinivas,
Why not use variables? My initial idea would be to use variables to calculate the value that you want to reuse in the other target field mappings.
Maybe I misunderstood what you meant.
Regards,
Mate
Hi Srinivas,
You need to repeat the mapping for target B and C except unless you use an UDF instead of standard functions to populate field A. Then only thing you need to change are the inputs to the UDF .
One UDF can also be sufficient if you use a UDF of type context with multiple inputs and 3 outputs one for each A , B and C.
Regards
Anupam
Add a comment