SOLVED
How to Summarize the last 'non blank' comment ?
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Dario02
7 - Meteor
03-02-2020
06:03 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Good morning,
Y have a new question.
the input is?
Ticket | Comment |
A | comment 1 |
B | |
C | comment 1 |
A | |
C | comment 2 |
B | comment 1 |
A | comment 2 |
A | comment 3 |
B | |
C | |
D |
What I want is
Ticket | Comment |
A | comment 3 |
B | comment 1 |
C | comment 2 |
D |
I am using the Summarize tool selecting the action "Last" but what I receive is some fields empty because the last comment is empty but I need to know the last non blank comment.
I hope it make sense.
Thanks in advance for any guidance
Solved! Go to Solution.
Labels:
- Labels:
- Workflow
5 REPLIES 5
17 - Castor
03-02-2020
06:14 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
03-02-2020
06:18 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
yalmar_m
11 - Bolide
03-02-2020
06:19 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
17 - Castor
03-02-2020
06:20 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
03-02-2020
06:23 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Both Solutions have worked perfectly.
Thanks to all.
