My requirement is to read the incoming string and compare the words with Dynamically created Table. In Utility DB I have created a table which has 3 fields Keywords(KeyWords contain 3 rows with value Hi|I|Am There|is Where|if|go) Rating (8 2 4) Email (ABC DEF ABC).
Now i have to read the incoming string and compare with Keyword Filed and append the rating according.
Payload Example 1
As a customer I would like to make a complaint and if I don’t get a response I will be sending a message
So the output should be found I, If. Rating 12
For retrieving MessageContent I have used Xpath in Expression shape. And i created Utility class where i am retrieving all the records as TableData and used this class in Expression shape to get the table contents.
Any suggestion how to proceed further.How to read each record\row using orchestration(looping).Please let me know the steps to be followed. For, Foreach loop is not working in Expression shape. Do i need to create an array for looping.