// 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)
@1 as id,
@2 as SmartFilter,
@3 as NoiseLevel
FROM $(vOutFingerprintScores) (txt, utf8, no labels, delimiter is ',', msq);