Use the KEEP ALL clause with an output window.
The example creates a schema named TradeSchema. The example creates an input window named TradeWindow that references TradeSchema, to which it attaches a File CSV Input adapter.
The example creates an output window named KeepAllWindow, which uses the KEEP ALL clause to retain all data from TradeWindow and group the results by Symbol.
CREATE OUTPUT WINDOW KeepAllWindow SCHEMA (Symbol string, RowCount INTEGER) PRIMARY KEY DEDUCED KEEP all AS SELECT TradeWindow.Symbol as Symbol, count(TradeWindow.Symbol) as RowCount FROM TradeWindow group by TradeWindow.Symbol ;