MATCHING clause

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.