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

[David-teryx]

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

[Prometheus]

@David-teryx I used the DateTimeParse expressions to turn your dates and times into actual dates and times then used conditional expressions to copy those values into the Error Fixed or Alert Fixed DATE and TIME fields. Is this what you're looking for?

 

[David-teryx]

@Prometheus I am looking to get the Date and Time from an Error/Alert Fixed type event and write that to the previous existing Error/Alert type event.

Example in Bold and Italic:

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	10/2/2023	14:03
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	10/2/2023	14:09
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

[Peachyco]

Interesting.

I have one concern: Is it possible to have two or more cases of "Print Open" at the same time? Like this:

RecordID	Description	Type	Date	Time
1	Print Open	Error	10/2/2023	13:59
2	Print Open	Error	10/2/2023	14:02
3	Print Open	Error Fixed	10/2/2023	14:03

This is important because if we have a situation like this, it'll be very difficult to determine which of the two "Print Open" cases was fixed.

[flying008]

Hi, @David-teryx 

Another way for you refer:

Input
RecordID	Description	Type	Date	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
Output
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	10/2/2023	14:03
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	10/2/2023	14:09
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	10/3/2023	18:03
12	Tape Out	Error Fixed	10/3/2023	18:03

******

How did you want process the event 'Alert Fixed' ? If you can upload more data for test , the logic will be clear up.

[David-teryx]

@Peachyco It could happen and every Print Open is fixed when at type column you get "Error Fixed". Always will be a Print Open Error and then a Print Open Error Fixed to have another Print Open Error.  

[David-teryx]

@flying008  looks like this is a good idea. Please share the Workflow file to see the way you did configure each tool to do that.

[David-teryx]

@Prometheus Thank you. This way the Date and Time was copied to the new columns on the same row. I am trying to get the Fixed event Date and Time and put it on the initial event fixed columns fro Date and Time.

[David-teryx]

@flying008  here is more data for this .
the event "Alert Fixed" is when the "Alert" event ends.  It is like for "Error" is "Error Fixed".

Please send me the workflow file you are using to be able to see how you configure the formula and tools . Thank you.

RecordID	Description	Type	Date	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
13	Tape Out	Error	10/3/2023	18:04
14	Print Paused	Alert	10/3/2023	18:05
15	Print Open	Error	10/3/2023	18:06
16	Print Open	Error Fixed	10/3/2023	18:06
17	Tape Out	Error Fixed	10/3/2023	18:09
18	Print Paused	Alert Fixed	10/3/2023	18:10
19	Cold Start Message	Alert	10/3/2023	19:25
20	Print Paused	Alert	10/3/2023	19:28
21	Print Paused	Alert Fixed	10/3/2023	19:30
22	Print Open	Error	10/3/2023	19:31
23	Print Paused	Alert	10/3/2023	19:31
24	Print Open	Error Fixed	10/3/2023	19:33
25	Print Paused	Alert Fixed	10/3/2023	19:50

[flying008]

Hi, @David-teryx 

What result is your want ? like this is right ?

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	10/2/2023	14:03
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	10/2/2023	14:09
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	10/3/2023	18:03
12	Tape Out	Error Fixed	10/3/2023	18:03
13	Tape Out	Error	10/3/2023	18:04	10/3/2023	18:06
14	Print Paused	Alert	10/3/2023	18:05
15	Print Open	Error	10/3/2023	18:06
16	Print Open	Error Fixed	10/3/2023	18:06
17	Tape Out	Error Fixed	10/3/2023	18:09
18	Print Paused	Alert Fixed	10/3/2023	18:10
19	Cold Start Message	Alert	10/3/2023	19:25
20	Print Paused	Alert	10/3/2023	19:28
21	Print Paused	Alert Fixed	10/3/2023	19:30
22	Print Open	Error	10/3/2023	19:31	10/3/2023	19:33
23	Print Paused	Alert	10/3/2023	19:31
24	Print Open	Error Fixed	10/3/2023	19:33
25	Print Paused	Alert Fixed	10/3/2023	19:50

******

Sorry, due to security policy restrictions, I am unable to upload workflow files, but please follow the tools I provided above, it is not complicated.