03_squirro.txt

03_squirro.txt
// call the command-line tool to get fingerprint noise levels for all bulk loaded data
//EXECUTE cmd.exe /C $(vSquirroBulkScorer);
// load the fingerprint noise levels for all bulk loaded data
// For each SmartFilter in Squirro each Squirro item is rated. This rating is now exported from Squirro via
// the bulk_scorer executable and imported in to the Qlik "Squirro" table. 
// This enables us to know the exact Squirro items to be shown when a SmartFilter is selected in the dashboard. 
// These items will be concatenated together for the Squirro GET query string (see 04_filters.txt -> vTicketFilter)
Squirro:
LOAD
    @1 as id,
    @2 as SmartFilter,
    @3 as NoiseLevel
FROM $(vOutFingerprintScores) (txt, utf8, no labels, delimiter is ',', msq);