you can try the followings:
JDBC Execute > Email Sender
JDBC Execute : SQL query that identify pending actions rows
Email Sender : place the recipient email from the data retrieved in the “To” field and placed the comments / details in the “Template body” field.
Keep in mind this is streaming execution. If there are 1000 rows then it will send 1000 email individually.
Can the data not be put into an HTML table so that snap treats it as one document ,so that users receive one email with their respective pending actions against their names in a table.
‘"+ $yourfield.split(’,‘).join(’','‘) +"’
Good to know using the simple join function to achieve the output. Thank you!!
With this expression, you should be able to make it work.
pipeline:
Test_Expression_2023_06_17 (1).slp (3.5 KB)
Let me know if that helps.
🙂
Cheers,
This worked perfect. I was trying something with the map function but was missing something. Thanks for the solution.
Hi @arvindnsn,
Did you try using the basic concatenation function?
I used a simple conditional statement in my mapper like below:
$field002!=""?" ' "+$field002+ " ' ":""
You might have to tweak a bit if you’re expecting multiple values in your second stream.
Yes, multiple ways to achieve the desired output. Some cover all use cases and some won’t. If you have an edge case scenario, that will need a custom formula.
Yes, Correct. Thank you for the suggestion and input!!
