How can I union tables and then apply a where filter? basically i want to find all items with the operation_Id == X
operation_Id == X
You can do this by specifying the tables for a union.
union table1, table2 | where operation_Id == "X"