Place a MATCHING clause on an output stream.
The example creates a schema named TradeSchema, then two input windows named InTrades and InTrades2, and an output stream named TradeOut that each reference TradeSchema.
TradeOut uses the MATCHING clause to retrieve rows that match over a one-second period.
CREATE OUTPUT STREAM TradeOut SCHEMA TradeSchema as SELECT FirstTrade.* FROM InTrades as FirstTrade, InTrades2 as SecondTrade MATCHING [1 seconds: FirstTrade , SecondTrade ] ON FirstTrade.Symbol = SecondTrade.Symbol ;
The example attaches a File CSV Input adapter named csvInConn1 to InTrades, and a File CSV Input adapter named csvInConn2 to InTrades2. The example also attaches a File CSV Output adapter named csvOut to TradeOut to publish the matching results to a file, since data cannot be viewed in-stream.