Hi all,
given are two log files from two different sources.
log 1
2021-05-03 10:00:38,656 INFO [Service TP] : | M_ID(3867) | ABC trade received from AFG via MM 2021-05-03 10:00:38,662 INFO [Service TP] : | M_ID(3867) | tradeReference: ABC82_00001 | Action Type: N ContractId: ABC82_00001 Version: | ABC trade mapping done. 2021-05-03 10:00:38,664 DEBUG [Service TP] : | M_ID(3867) | tradeReference: ABC82_00001 | Action Type: N | for destinations: AAB 2021-05-03 10:00:38,669 DEBUG [Service TP] : | M_ID(3867) | tradeReference: ABC82_00001 | Action Type: N | DataEnchrichment Status : 15101 2021-05-03 10:00:38,671 INFO [Service TP] : | M_ID(3867) | tradeReference: ABC82_00001 | successfully sent to destinations: AAB | MessageID: (2065)
Log 2
2021-05-03 10:00:38,675 INFO [Service TP] : | M_ID(2065) | AAB trade received from Host via PK 2021-05-03 10:00:38,684 INFO [Service TP] : | M_ID(2065) | tradeReference: ABC82_00001 | Action Type: N ContractId: ABC82_00001 Version: | AAB trade mapping done. 2021-05-03 10:00:38,687 INFO [Service TP] : | M_ID(2065) | tradeReference: ABC82_00001 | Action Type: | MessageID: (3984)
I have parsed both logs into a single index under the following fields:
* tradeReference : ABC82_00001
* ContractId : ABC82_00001
* log_1_M_ID : 3867
* log_2_M_ID : 2065
* log_1_MessageID : 2065
* log_2_MessageID : 3984
* level : INFO/DEBUG
* Date : the date of every singel line
What I want is the following: a data table where I can track the tradeReference from log_1 with date from log_1 and the same tradeReference from log_2 with date from log_2 and at the end calculate the duration between date from log_1 and date from log_2, here is an example of an expected table:
it is an emergency, can someone help with something or give a suggestion.
Thank you very much