Hello Friends,
I am working on a monthly report where I would combine previous month report and current month report and publish it in an email. The ask is whenever there is any new row is added from previous month the row should be separately highlighted with color. My current workflow combines the two data and using table tool and email tool I publish the output in email body. But this is an additional requirement. Can anyone assist.
I need the output as mentioned below in output section.
Current month-
Main_Party | Sub_party | DOB | Flag | Roles | Accounts |
1233 | A122 | 3/16/2024 | Y | Owner | N |
4588 | A123 | 2/17/2024 | Y | Joint | N |
3566 | A124 | 3/21/2024 | Y | Nominee | N |
4895 | A125 | 3/1/2024 | Y | Owner | N |
Previous month
Main_Party | Sub_party | DOB | Flag | Roles | Accounts |
4588 | A123 | 2/17/2024 | Y | Joint | N |
3566 | A124 | 3/21/2024 | Y | Nominee | N |
4895 | A125 | 3/1/2024 | Y | Owner | N |
Output-
Main_Party | Sub_party | DOB | Flag | Roles | Accounts |
1233 | A122 | 3/16/2024 | Y | Owner | N |
4588 | A123 | 2/17/2024 | Y | Joint | N |
3566 | A124 | 3/21/2024 | Y | Nominee | N |
4895 | A125 | 3/1/2024 | Y | Owner | N |
Solved! Go to Solution.
Can anyone assist on this
@Saravanan13 one way of doing this
Thank you so much, It is perfect for my solution.