AnsweredAssumed Answered

how to concat and map multiple occurences of input field to single output field?

Question asked by shaik.desowja on Dec 10, 2017
Latest reply on Dec 11, 2017 by abupp137129

Hi All,

Above is the sample payload.. Based upon code value I need to do implement following logic:

 

code1="";
if(code=="Invoices paid (Remittance)"){
code1+="REMIT";
}

if(code=="Purchase documents created or changed (PUR)"){
code1+="PUR";
}

if(code=="Invoices returned (RTV)"){
code1+="RTV";
}
if(code=="Electronic Invoices (E-invoice)"){
code1+="EINVOICE";
}
if(code=="Commercia Contact"){
code1+="COMMERCIAL";
}
if(code=="Any Other Purpose"){
code1+="Others";
}

 

Requirement: If there are multiple occurrence code tag in input data I need to concat all the code tags with comma into single destination field whose occurrence is 0 to 1.

 For example: expected output from above input :- REMIT,PUR.

 

Now how to fetch multiple occurrence of code values into single variable with comma separated in single file. The destination field occurrence is 0 to 1

As of now for 2 different code tags I am getting 2 output files.

 

Please Help!!!! 

Outcomes