cancel
Showing results for 
Search instead for 
Did you mean: 

sproxy to mail with table format

Former Member
0 Kudos

Hi experts ,

my requirement is sproxy to mail successfully executed in this scenario i wrote one user defined function like combine five fields in message mapping the fields are TransactionID,TransactionDate, CustomerID, TransactionAmount,RefundAmount

UDF code

public void CombineText(String[] var1, String[] var2, String[] var3, String[] var4, String[] var5, ResultList result, Container container) throws StreamTransformationException{

String s = "";

for( int i = 0 ; i < var1.length ; i++)

{

if ( var1<i> != ResultList.CC)

s = s + var1<i> + " " + var2<i> + " " + var3<i> + " " + var4<i> + " " + var5<i> + "\n" ;

}

result.addValue( s );

}

var1 -- TransactionID ,var2 -- TransactionDate var2--CustomerID var3-TransactionAmount var5-RefundAmount

3988765433221899,20110425,BILLDESK3983,11100,11100

4878000000011118,20110429,BILLDE911094,55100,55100

ABCD000111122222,20110424,YJANARDHAN,222300,222300

now i want below structure pattern

-


TransactionID TransactionDate CustomerID TransactionAmount RefundAmount

-


3988765433221899 20110425 BILLDESK3983 11100 11100

4878000000011118 20110429 BILLDE911094 55100 55100

ABCD000111122222 20110424 YJANARDHAN 222300 222300

-


so please kindly provide UDF code or other inputs

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

sorry, what is a problem?

please show me nowly your UDF output and your ideal UDF out put.

dont worry, maybe this is not difficlt problem, I think.