I'm trying to map an input payload to specific member numbers based on a combination of street address and department. I have a mapping sheet with the following information:
Mapping Sheet:
Street, Department, MemberNo
123 main st, agent ,12341
1123 main st, agent, 1674
123 main street, operations, 1298
Input Payload:
{
"name": "xya",
"lastname": "hagsdg",
"street": "123 M St",
"dept": "agent service"
}
Match the street address from the input with one of the street addresses in my mapping sheet (with potential variations like
"123 M St"
vs.
"123 main st"
).
Match the department from the input with one of the departments in the mapping sheet (for example,
"agent service"
should match
"agent"
).
Assign the corresponding member number (
memberno
) based on the matched street and department.
I want max match memberno
@Carrie Donovan @Training: DataWeave 2.0 with Mule 4 @Manish Yadav @Anurag Sharma @Shekh Muenuddeen @Shyam Raj Prasad @Gopal E @Ryan Anthony Andal @Scott Silbernick @Chetan Joshi @Manik Magar @Saddam Shaikh
Thanks for the DataWeave. The "M" is shorthand for "Main," like in "12 M Rd." Customers are sending it this way from the frontend.
