Hi Lukas, I appreciate the help above, but I don't think I typed out my question correctly. What I'd like to find out is how to find the txn_id of the logs which have the log_type "MER_REQUEST", but do not have the log_type "MER_RESPONSE".
A log with txn_id, "ABC123" has 4 logs, with one being "MER_REQUEST", another being "MER_RESPONSE" and the remaining being other random log types.
Another log with txn_id, "DEF456" has 6 logs, with one being "MER_REQUEST" and the remaining being other random log types.
I'd like to find the logs like "DEF456" and have them displayed in a data table visualization, but I can't seem to find a method to do so.