How can I union tables and then apply a where filter? basically i want to find all items with the operation_Id == X
You can do this by specifying the tables for a union.
union table1, table2 | where operation_Id == "X"
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With