Hello, I have this example has initial event types like "Error" or "Alert" with final event types like "Error Fixed" or "Alert Fixed". The Data have initial event and final event on different rows and always are in that sequence. For all Error event or Alert event there is a Fixed event before we can see another Error event.
I am trying to get the Date and the Time from the final events and insert that value on new columns, so I can have the inital event Date/Time and Final Date/Time on the same row to read the event in one single row.
There is no other data available to identify relation between initial and final event.
I appreciate any help, thank you.
RecordID | Description | Type | Date | Time | Error Fixed or Alert Fixed DATE | Error Fixed or Alert Fixed TIME |
1 | Print Open | Error Fixed | 10/2/2023 | 14:02 | ||
2 | Print Open | Error | 10/2/2023 | 14:02 | ||
3 | Print Open | Error Fixed | 10/2/2023 | 14:03 | ||
4 | Print Paused | Alert Fixed | 10/2/2023 | 14:03 | ||
5 | Paper Out | Error | 10/2/2023 | 14:04 | ||
6 | Printer Paused | Alert | 10/2/2023 | 14:07 | ||
7 | Print Open | Error | 10/2/2023 | 14:08 | ||
8 | Paper Out | Error Fixed | 10/2/2023 | 14:09 | ||
9 | Print Open | Error Fixed | 10/2/2023 | 14:11 | ||
10 | Print Paused | Alert Fixed | 10/2/2023 | 14:12 | ||
11 | Tape Out | Error | 10/3/2023 | 18:03 | ||
12 | Tape Out | Error Fixed | 10/3/2023 | 18:03 |
Hello @flying008 Yes it is the result I want. I already tried to guess the way you configure the tools and got no luck to replicate what you did.
The Gif you sent me is not clear to my understanding of this. If you are unable to upload the workflow file, Please let me know the way you configure the tools: Multi-Row Formula, Multi-Field Formula, Formula and Find Replace tools.
I appreciate your help on this.