Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Help - Data with initial event and final event on different rows

David-teryx
7 - Meteor

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.

 

RecordIDDescriptionTypeDateTimeError Fixed or Alert Fixed DATEError Fixed or Alert Fixed TIME
1Print OpenError Fixed10/2/202314:02  
2Print OpenError10/2/202314:02  
3Print OpenError Fixed10/2/202314:03  
4Print PausedAlert Fixed10/2/202314:03  
5Paper OutError10/2/202314:04  
6Printer PausedAlert10/2/202314:07  
7Print OpenError10/2/202314:08  
8Paper OutError Fixed10/2/202314:09  
9Print OpenError Fixed10/2/202314:11  
10Print PausedAlert Fixed10/2/202314:12  
11Tape OutError10/3/202318:03  
12Tape OutError Fixed10/3/202318:03  
10 REPLIES 10
David-teryx
7 - Meteor

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.

Labels