{ "version": 5, "savedAt": "2026-11-01T23:14:27.140Z", "projects": { "p1": { "id": "p1", "name": "Q-Expert Distributors", "author": "The Q-Fábrica team", "desc": "", "rootPath": "lib://QVD/", "txfPath": "lib://QXDistributors/Transform/", "qvsSubfolder": "_QVS", "busPath": "", "srcPaths": [ { "libPath": "lib://QXDistributors/", "label": "source", "_cachedFiles": [], "folderName": "QXDistributors", "varName": "vPathRaw", "fileHandles": [] } ], "envProfiles": [ { "id": "env2", "name": "Default", "srcPaths": [ { "libPath": "lib://QXDistributors/", "label": "source", "_cachedFiles": [], "folderName": "QXDistributors", "varName": "vPathRaw" } ], "exportDirLabel": "" } ], "activeEnvProfileId": "env2", "vars": [ { "name": "vEnvironment", "value": "PROD", "desc": "PROD, QA or DEV" }, { "name": "vBaseCurrency", "value": "COP", "desc": "Currency every amount is converted to" }, { "name": "vPathModel", "value": "lib://QXDistributors/Model/", "desc": "The model QVDs the apps load" } ], "header": "/*----------------------------------------------------------------------------------------\n\tDescription [{{layer}}]:\n\t\t{{description}}\n\t-------------------------------------------------------------------------------------\n\tAuthor:\t{{author}} - {{role}}\n\tDate:\t[{{date}}]\n\t-------------------------------------------------------------------------------------\n\tChanges\n\t-------------------------------------------------------------------------------------\n\tAuthor\t\tDate\t\tDetail\n\t-------------------------------------------------------------------------------------\n\n\t-------------------------------------------------------------------------------------\n\tCopyright © {{project}}.\n\tQ-Expert Qlik Developer Framework. www.qfabrica.com\n----------------------------------------------------------------------------------------*/", "library": [ { "id": "lib3", "name": "Sales_2025_01", "type": "csv", "path": "lib://QXDistributors/Sales_2025_01.csv", "desc": "", "size": 4707, "columns": [ { "name": "SaleID", "active": true, "dtype": "number", "transform": null }, { "name": "SaleDate", "active": true, "dtype": "date", "transform": null }, { "name": "CustomerID", "active": true, "dtype": "number", "transform": null }, { "name": "ProductID", "active": true, "dtype": "number", "transform": null }, { "name": "SalespersonID", "active": true, "dtype": "number", "transform": null }, { "name": "BranchID", "active": true, "dtype": "number", "transform": null }, { "name": "Quantity", "active": true, "dtype": "number", "transform": null }, { "name": "UnitPrice", "active": true, "dtype": "number", "transform": null }, { "name": "DiscountPct", "active": true, "dtype": "number", "transform": null }, { "name": "Currency", "active": true, "dtype": "string", "transform": null }, { "name": "Channel", "active": true, "dtype": "string", "transform": null } ], "sheetNames": null, "sheetColumns": null, "isWildcard": false, "wcPattern": "lib://QXDistributors/Sales_*.csv", "wcGroup": "Sales", "wcExcluded": false, "missing": false, "previewData": { "columns": [ "SaleID", "SaleDate", "CustomerID", "ProductID", "SalespersonID", "BranchID", "Quantity", "UnitPrice", "DiscountPct", "Currency", "Channel" ], "rows": [ [ "1", "2025-01-26", "43", "8", "10", "3", "7", "44100", "0", "COP", "P" ], [ "2", "2025-01-18", "9", "12", "8", "6", "8", "54000", "15", "COP", "T" ], [ "3", "2025-01-27", "52", "1", "2", "1", "19", "21900", "15", "COP", "W" ], [ "4", "2025-01-24", "50", "23", "6", "1", "17", "88200", "0", "COP", "P" ], [ "5", "2025-01-01", "41", "27", "1", "4", "-2", "70300", "10", "COP", "W" ], [ "6", "2025-01-05", "21", "16", "4", "2", "3", "45000", "15", "COP", "P" ], [ "7", "2025-01-17", "21", "8", "9", "6", "1", "44100", "5", "COP", "T" ], [ "8", "2025-01-17", "55", "2", "9", "7", "9", "68600", "10", "COP", "P" ], [ "9", "2025-01-23", "9", "22", "2", "8", "1", "25900", "0", "COP", "P" ], [ "10", "2025-01-25", "999", "17", "7", "7", "12", "51700", "0", "COP", "W" ], [ "11", "2025-01-02", "37", "39", "2", "3", "15", "90700", "10", "COP", "P" ], [ "12", "2025-01-30", "33", "3", "6", "7", "5", "43100", "0", "COP", "T" ], [ "13", "2025-01-24", "47", "25", "9", "7", "-3", "71300", "0", "COP", "P" ], [ "14", "2025-01-26", "999", "5", "7", "4", "13", "3", "10", "USD", "P" ], [ "15", "2025-01-11", "8", "29", "11", "4", "24", "62600", "0", "COP", "W" ], [ "16", "2025-01-18", "55", "11", "6", "6", "13", "70600", "0", "COP", "P" ], [ "17", "2025-01-21", "22", "13", "2", "5", "13", "56400", "0", "COP", "P" ], [ "18", "2025-01-26", "53", "36", "5", "4", "-1", "21.07", "10", "USD", "P" ], [ "19", "2025-01-26", "15", "4", "6", "1", "2", "3200", "0", "COP", "P" ], [ "20", "2025-01-21", "42", "32", "5", "1", "9", "11000", "0", "COP", "P" ], [ "21", "2025-01-10", "27", "7", "10", "1", "19", "8.41", "0", "USD", "T" ], [ "22", "2025-01-06", "9", "26", "8", "5", "4", "69400", "0", "COP", "P" ], [ "23", "2025-01-12", "47", "32", "7", "8", "11", "11000", "0", "COP", "P" ], [ "24", "2025-01-27", "16", "4", "7", "1", "8", "3200", "0", "COP", "P" ], [ "25", "2025-01-01", "46", "2", "3", "5", "16", "68600", "0", "COP", "W" ], [ "26", "2025-01-14", "16", "38", "3", "7", "8", "64700", "0", "COP", "W" ], [ "27", "2025-01-19", "51", "24", "11", "5", "9", "41800", "10", "COP", "W" ], [ "28", "2025-01-03", "40", "7", "4", "5", "13", "34500", "0", "COP", "W" ], [ "29", "2025-01-19", "25", "18", "3", "4", "10", "74300", "10", "COP", "P" ], [ "30", "2025-01-15", "15", "27", "3", "5", "15", "70300", "10", "COP", "P" ], [ "31", "2025-01-11", "55", "25", "10", "4", "16", "71300", "15", "COP", "T" ], [ "32", "2025-01-18", "5", "31", "2", "3", "14", "46500", "0", "COP", "T" ], [ "33", "2025-01-09", "57", "2", "7", "6", "-3", "16.73", "0", "USD", "W" ], [ "34", "2025-01-22", "23", "37", "7", "8", "17", "84500", "0", "COP", "P" ], [ "35", "2025-01-16", "26", "13", "12", "8", "19", "56400", "0", "COP", "P" ], [ "36", "2025-01-13", "999", "39", "4", "2", "-3", "90700", "5", "COP", "P" ], [ "37", "2025-01-29", "999", "25", "3", "6", "21", "71300", "10", "COP", "P" ], [ "38", "2025-01-08", "54", "26", "8", "8", "9", "69400", "15", "COP", "P" ], [ "39", "2025-01-05", "31", "3", "4", "5", "13", "43100", "5", "COP", "W" ], [ "40", "2025-01-03", "24", "29", "11", "8", "18", "62600", "15", "COP", "W" ], [ "41", "2025-01-27", "24", "40", "6", "3", "22", "5.22", "0", "USD", "P" ], [ "42", "2025-01-28", "41", "11", "8", "4", "14", "70600", "0", "COP", "P" ], [ "43", "2025-01-24", "48", "32", "10", "6", "23", "11000", "5", "COP", "P" ], [ "44", "2025-01-23", "55", "3", "8", "5", "4", "43100", "15", "COP", "W" ], [ "45", "2025-01-17", "7", "32", "1", "2", "16", "11000", "10", "COP", "T" ], [ "46", "2025-01-29", "31", "35", "7", "5", "4", "14.41", "0", "USD", "T" ], [ "47", "2025-01-23", "58", "38", "10", "1", "24", "64700", "15", "COP", "P" ], [ "48", "2025-01-14", "53", "2", "5", "8", "6", "68600", "10", "COP", "W" ], [ "49", "2025-01-22", "54", "26", "6", "2", "12", "69400", "15", "COP", "T" ], [ "50", "2025-01-20", "19", "36", "1", "5", "8", "86400", "0", "COP", "P" ], [ "51", "2025-01-16", "56", "19", "11", "5", "17", "13700", "10", "COP", "T" ], [ "52", "2025-01-16", "24", "20", "6", "1", "16", "53300", "0", "COP", "P" ], [ "53", "2025-01-19", "20", "8", "10", "3", "3", "44100", "10", "COP", "T" ], [ "54", "2025-01-23", "44", "28", "10", "6", "20", "12.07", "0", "USD", "T" ], [ "55", "2025-01-22", "18", "9", "1", "4", "10", "60200", "0", "COP", "P" ], [ "56", "2025-01-29", "36", "17", "10", "3", "24", "51700", "10", "COP", "T" ], [ "57", "2025-01-04", "48", "15", "5", "4", "6", "80400", "0", "COP", "P" ], [ "58", "2025-01-22", "39", "7", "2", "2", "8", "34500", "0", "COP", "W" ], [ "59", "2025-01-30", "44", "20", "4", "6", "4", "53300", "10", "COP", "P" ], [ "60", "2025-01-01", "9", "1", "9", "7", "-1", "21900", "0", "COP", "W" ], [ "61", "2025-01-29", "59", "36", "6", "4", "6", "86400", "0", "COP", "P" ], [ "62", "2025-01-16", "9", "13", "3", "6", "22", "56400", "0", "COP", "P" ], [ "63", "2025-01-09", "42", "10", "1", "7", "5", "40200", "15", "COP", "T" ], [ "64", "2025-01-04", "57", "11", "1", "4", "3", "70600", "0", "COP", "W" ], [ "65", "2025-01-13", "19", "28", "9", "3", "10", "12.07", "15", "USD", "P" ], [ "66", "2025-01-20", "7", "34", "4", "5", "22", "54300", "0", "COP", "P" ], [ "67", "2025-01-18", "11", "25", "7", "3", "23", "71300", "15", "COP", "T" ], [ "68", "2025-01-09", "48", "17", "3", "5", "24", "51700", "5", "COP", "P" ], [ "69", "2025-01-30", "19", "5", "6", "5", "3", "12300", "0", "COP", "P" ], [ "70", "2025-01-11", "18", "26", "12", "5", "20", "69400", "0", "COP", "P" ], [ "71", "2025-01-03", "30", "39", "12", "4", "10", "90700", "0", "COP", "T" ], [ "72", "2025-01-31", "13", "8", "7", "1", "20", "10.76", "10", "USD", "P" ], [ "73", "2025-01-07", "59", "5", "4", "4", "23", "12300", "5", "COP", "P" ], [ "74", "2025-01-29", "23", "40", "10", "1", "16", "21400", "5", "COP", "P" ], [ "75", "2025-01-30", "23", "37", "4", "5", "12", "20.61", "15", "USD", "P" ], [ "76", "2025-01-16", "50", "32", "6", "2", "23", "11000", "0", "COP", "T" ], [ "77", "2025-01-26", "28", "1", "6", "8", "11", "21900", "0", "COP", "W" ], [ "78", "2025-01-30", "11", "29", "3", "3", "20", "62600", "0", "COP", "P" ], [ "79", "2025-01-31", "48", "28", "4", "1", "17", "12.07", "10", "USD", "P" ], [ "80", "2025-01-24", "7", "8", "7", "1", "2", "44100", "10", "COP", "W" ], [ "81", "2025-01-08", "46", "29", "3", "8", "7", "62600", "0", "COP", "P" ], [ "82", "2025-01-04", "21", "24", "7", "1", "2", "41800", "0", "COP", "P" ], [ "83", "2025-01-15", "14", "5", "8", "1", "15", "12300", "0", "COP", "W" ], [ "84", "2025-01-08", "9", "27", "4", "8", "10", "70300", "0", "COP", "P" ], [ "85", "2025-01-16", "14", "30", "8", "4", "20", "29600", "15", "COP", "T" ], [ "86", "2025-01-30", "56", "35", "5", "2", "16", "59100", "0", "COP", "W" ], [ "87", "2025-01-13", "28", "29", "4", "8", "21", "62600", "15", "COP", "W" ], [ "88", "2025-01-30", "53", "7", "4", "2", "4", "34500", "5", "COP", "W" ], [ "89", "2025-01-28", "1", "11", "2", "2", "18", "70600", "0", "COP", "P" ], [ "90", "2025-01-21", "57", "22", "2", "3", "11", "25900", "0", "COP", "P" ], [ "91", "2025-01-16", "6", "40", "5", "8", "1", "21400", "10", "COP", "W" ], [ "92", "2025-01-28", "8", "40", "8", "1", "23", "21400", "15", "COP", "W" ], [ "93", "2025-01-23", "44", "32", "1", "4", "10", "11000", "0", "COP", "P" ], [ "94", "2025-01-25", "29", "4", "2", "6", "4", "0.78", "0", "USD", "W" ], [ "95", "2025-01-15", "14", "33", "7", "5", "14", "39500", "0", "COP", "W" ], [ "96", "2025-01-27", "56", "8", "9", "3", "23", "44100", "10", "COP", "P" ], [ "97", "2025-01-25", "13", "23", "9", "5", "18", "21.51", "5", "USD", "W" ], [ "98", "2025-01-16", "12", "10", "1", "8", "24", "40200", "15", "COP", "P" ], [ "99", "2025-01-08", "5", "17", "7", "6", "10", "51700", "15", "COP", "T" ], [ "100", "2025-01-18", "23", "19", "7", "3", "13", "13700", "0", "COP", "T" ] ] }, "_rowCount": 110 }, { "id": "lib4", "name": "Sales_2025_02", "type": "csv", "path": "lib://QXDistributors/Sales_2025_02.csv", "desc": "", "size": 4821, "columns": [ { "name": "SaleID", "active": true, "dtype": "number", "transform": null }, { "name": "SaleDate", "active": true, "dtype": "date", "transform": null }, { "name": "CustomerID", "active": true, "dtype": "number", "transform": null }, { "name": "ProductID", "active": true, "dtype": "number", "transform": null }, { "name": "SalespersonID", "active": true, "dtype": "number", "transform": null }, { "name": "BranchID", "active": true, "dtype": "number", "transform": null }, { "name": "Quantity", "active": true, "dtype": "number", "transform": null }, { "name": "UnitPrice", "active": true, "dtype": "number", "transform": null }, { "name": "DiscountPct", "active": true, "dtype": "number", "transform": null }, { "name": "Currency", "active": true, "dtype": "string", "transform": null }, { "name": "Channel", "active": true, "dtype": "string", "transform": null } ], "sheetNames": null, "sheetColumns": null, "isWildcard": false, "wcPattern": "lib://QXDistributors/Sales_*.csv", "wcGroup": "Sales", "wcExcluded": false, "missing": false, "previewData": { "columns": [ "SaleID", "SaleDate", "CustomerID", "ProductID", "SalespersonID", "BranchID", "Quantity", "UnitPrice", "DiscountPct", "Currency", "Channel" ], "rows": [ [ "111", "2025-02-18", "7", "9", "11", "7", "14", "60200", "10", "COP", "T" ], [ "112", "2025-02-20", "40", "34", "9", "6", "4", "54300", "15", "COP", "W" ], [ "113", "2025-02-28", "40", "37", "1", "2", "2", "20.61", "0", "USD", "W" ], [ "114", "2025-02-03", "56", "34", "1", "4", "11", "54300", "0", "COP", "P" ], [ "115", "2025-02-14", "999", "36", "12", "3", "12", "86400", "0", "COP", "T" ], [ "116", "2025-02-20", "33", "1", "2", "7", "4", "21900", "15", "COP", "P" ], [ "117", "2025-02-12", "37", "27", "12", "6", "15", "70300", "15", "COP", "P" ], [ "118", "2025-02-21", "4", "39", "2", "2", "17", "90700", "0", "COP", "T" ], [ "119", "2025-02-18", "50", "27", "11", "3", "17", "70300", "0", "COP", "P" ], [ "120", "2025-02-01", "999", "2", "9", "7", "23", "68600", "10", "COP", "P" ], [ "121", "2025-02-19", "18", "28", "5", "7", "3", "49500", "0", "COP", "W" ], [ "122", "2025-02-10", "6", "8", "8", "3", "21", "44100", "0", "COP", "P" ], [ "123", "2025-02-25", "50", "17", "6", "2", "10", "51700", "5", "COP", "W" ], [ "124", "2025-02-26", "58", "15", "4", "2", "18", "80400", "0", "COP", "P" ], [ "125", "2025-02-14", "29", "6", "11", "4", "12", "40200", "10", "COP", "W" ], [ "126", "2025-02-17", "59", "34", "9", "8", "4", "54300", "15", "COP", "P" ], [ "127", "2025-02-16", "60", "36", "7", "8", "24", "86400", "10", "COP", "W" ], [ "128", "2025-02-02", "24", "37", "4", "2", "4", "20.61", "0", "USD", "P" ], [ "129", "2025-02-01", "14", "13", "6", "2", "1", "13.76", "0", "USD", "W" ], [ "130", "2025-02-06", "55", "4", "5", "4", "8", "3200", "15", "COP", "T" ], [ "131", "2025-02-07", "42", "26", "12", "3", "7", "69400", "0", "COP", "P" ], [ "132", "2025-02-17", "36", "5", "2", "4", "21", "12300", "10", "COP", "P" ], [ "133", "2025-02-03", "44", "28", "1", "4", "16", "49500", "15", "COP", "W" ], [ "134", "2025-02-06", "5", "7", "1", "7", "19", "34500", "0", "COP", "P" ], [ "135", "2025-02-16", "12", "32", "4", "7", "6", "2.68", "10", "USD", "T" ], [ "136", "2025-02-16", "21", "40", "12", "4", "24", "21400", "15", "COP", "P" ], [ "137", "2025-02-11", "999", "10", "10", "8", "19", "40200", "10", "COP", "P" ], [ "138", "2025-02-19", "31", "1", "4", "7", "4", "21900", "0", "COP", "P" ], [ "139", "2025-02-05", "48", "17", "12", "7", "21", "51700", "0", "COP", "T" ], [ "140", "2025-02-05", "52", "1", "6", "7", "17", "21900", "0", "COP", "T" ], [ "141", "2025-02-16", "34", "33", "8", "6", "18", "39500", "0", "COP", "T" ], [ "142", "2025-02-07", "33", "30", "5", "2", "15", "29600", "5", "COP", "P" ], [ "143", "2025-02-08", "40", "16", "2", "4", "15", "45000", "0", "COP", "P" ], [ "144", "2025-02-25", "4", "23", "10", "2", "23", "88200", "0", "COP", "T" ], [ "145", "2025-02-16", "31", "18", "10", "2", "14", "74300", "10", "COP", "W" ], [ "146", "2025-02-20", "55", "19", "3", "6", "15", "13700", "15", "COP", "T" ], [ "147", "2025-02-07", "27", "32", "6", "8", "11", "2.68", "10", "USD", "P" ], [ "148", "2025-02-14", "60", "5", "4", "7", "20", "12300", "0", "COP", "W" ], [ "149", "2025-02-22", "12", "29", "10", "4", "1", "62600", "10", "COP", "P" ], [ "150", "2025-02-22", "23", "3", "1", "2", "13", "43100", "10", "COP", "P" ], [ "151", "2025-02-06", "51", "14", "4", "6", "10", "23200", "5", "COP", "W" ], [ "152", "2025-02-02", "46", "28", "5", "8", "8", "49500", "0", "COP", "P" ], [ "153", "2025-02-09", "23", "2", "4", "3", "22", "16.73", "0", "USD", "P" ], [ "154", "2025-02-14", "57", "11", "5", "1", "15", "70600", "10", "COP", "W" ], [ "155", "2025-02-09", "1", "15", "2", "1", "21", "80400", "0", "COP", "T" ], [ "156", "2025-02-22", "54", "40", "4", "8", "22", "21400", "0", "COP", "W" ], [ "157", "2025-02-04", "40", "39", "3", "1", "8", "90700", "0", "COP", "T" ], [ "158", "2025-02-18", "5", "3", "12", "5", "21", "43100", "15", "COP", "P" ], [ "159", "2025-02-27", "49", "30", "6", "7", "14", "29600", "0", "COP", "W" ], [ "160", "2025-02-28", "40", "37", "7", "4", "8", "84500", "10", "COP", "T" ], [ "161", "2025-02-01", "45", "20", "1", "2", "9", "53300", "0", "COP", "T" ], [ "162", "2025-02-16", "11", "5", "10", "7", "13", "12300", "0", "COP", "W" ], [ "163", "2025-02-18", "45", "34", "10", "1", "8", "54300", "0", "COP", "W" ], [ "164", "2025-02-06", "57", "9", "7", "3", "17", "14.68", "5", "USD", "P" ], [ "165", "2025-02-24", "2", "23", "12", "4", "4", "88200", "15", "COP", "W" ], [ "166", "2025-02-17", "33", "23", "11", "8", "22", "88200", "5", "COP", "T" ], [ "167", "2025-02-01", "31", "13", "10", "8", "10", "56400", "0", "COP", "P" ], [ "168", "2025-02-17", "54", "22", "2", "2", "23", "25900", "0", "COP", "T" ], [ "169", "2025-02-08", "16", "7", "3", "3", "17", "34500", "0", "COP", "P" ], [ "170", "2025-02-28", "50", "27", "2", "8", "2", "70300", "5", "COP", "T" ], [ "171", "2025-02-03", "43", "29", "4", "4", "18", "62600", "0", "COP", "P" ], [ "172", "2025-02-01", "58", "10", "8", "1", "4", "40200", "15", "COP", "W" ], [ "173", "2025-02-21", "41", "16", "3", "3", "21", "45000", "0", "COP", "T" ], [ "174", "2025-02-24", "29", "17", "8", "2", "10", "51700", "5", "COP", "W" ], [ "175", "2025-02-27", "27", "14", "3", "5", "24", "23200", "5", "COP", "T" ], [ "176", "2025-02-18", "29", "38", "5", "6", "20", "15.78", "0", "USD", "P" ], [ "177", "2025-02-14", "16", "5", "9", "5", "6", "3", "5", "USD", "W" ], [ "178", "2025-02-11", "12", "34", "4", "5", "16", "54300", "10", "COP", "W" ], [ "179", "2025-02-07", "35", "28", "1", "3", "21", "49500", "0", "COP", "P" ], [ "180", "2025-02-11", "60", "17", "4", "4", "9", "51700", "0", "COP", "P" ], [ "181", "2025-02-11", "999", "21", "6", "6", "3", "65000", "15", "COP", "P" ], [ "182", "2025-02-01", "44", "24", "6", "6", "11", "41800", "0", "COP", "P" ], [ "183", "2025-02-01", "31", "20", "6", "6", "8", "53300", "5", "COP", "P" ], [ "184", "2025-02-08", "44", "15", "10", "2", "22", "80400", "0", "COP", "P" ], [ "185", "2025-02-01", "1", "36", "6", "4", "6", "86400", "5", "COP", "P" ], [ "186", "2025-02-11", "50", "31", "5", "1", "2", "11.34", "0", "USD", "P" ], [ "187", "2025-02-06", "41", "22", "8", "4", "6", "25900", "5", "COP", "T" ], [ "188", "2025-02-18", "6", "1", "6", "7", "19", "21900", "10", "COP", "W" ], [ "189", "2025-02-06", "43", "17", "8", "3", "20", "12.61", "0", "USD", "T" ], [ "190", "2025-02-27", "42", "18", "10", "5", "24", "74300", "0", "COP", "P" ], [ "191", "2025-02-19", "22", "18", "11", "6", "7", "74300", "0", "COP", "P" ], [ "192", "2025-02-16", "56", "31", "4", "8", "12", "46500", "0", "COP", "T" ], [ "193", "2025-02-07", "45", "2", "8", "1", "1", "68600", "0", "COP", "T" ], [ "194", "2025-02-09", "45", "35", "2", "7", "5", "59100", "15", "COP", "P" ], [ "195", "2025-02-17", "29", "13", "11", "8", "13", "56400", "0", "COP", "P" ], [ "196", "2025-02-11", "34", "25", "2", "8", "24", "17.39", "0", "USD", "P" ], [ "197", "2025-02-26", "15", "21", "9", "8", "14", "65000", "0", "COP", "T" ], [ "198", "2025-02-05", "24", "16", "11", "3", "12", "45000", "0", "COP", "T" ], [ "199", "2025-02-10", "16", "18", "4", "3", "16", "74300", "0", "COP", "P" ], [ "200", "2025-02-11", "46", "22", "4", "8", "13", "25900", "5", "COP", "P" ], [ "201", "2025-02-09", "53", "35", "8", "2", "20", "59100", "0", "COP", "P" ], [ "202", "2025-02-28", "55", "26", "9", "5", "19", "69400", "15", "COP", "P" ], [ "203", "2025-02-17", "55", "5", "4", "7", "8", "12300", "0", "COP", "P" ], [ "204", "2025-02-25", "40", "21", "6", "2", "8", "65000", "0", "COP", "P" ], [ "205", "2025-02-26", "2", "13", "2", "4", "23", "56400", "0", "COP", "P" ], [ "206", "2025-02-11", "57", "15", "3", "7", "15", "80400", "0", "COP", "W" ], [ "207", "2025-02-21", "47", "19", "3", "8", "24", "13700", "5", "COP", "W" ], [ "208", "2025-02-03", "9", "31", "5", "8", "7", "46500", "10", "COP", "W" ], [ "209", "2025-02-24", "29", "3", "1", "5", "4", "10.51", "10", "USD", "T" ], [ "210", "2025-02-11", "21", "18", "9", "3", "10", "74300", "0", "COP", "P" ] ] }, "_rowCount": 110 }, { "id": "lib5", "name": "Sales_2025_03", "type": "csv", "path": "lib://QXDistributors/Sales_2025_03.csv", "desc": "", "size": 4814, "columns": [ { "name": "SaleID", "active": true, "dtype": "number", "transform": null }, { "name": "SaleDate", "active": true, "dtype": "date", "transform": null }, { "name": "CustomerID", "active": true, "dtype": "number", "transform": null }, { "name": "ProductID", "active": true, "dtype": "number", "transform": null }, { "name": "SalespersonID", "active": true, "dtype": "number", "transform": null }, { "name": "BranchID", "active": true, "dtype": "number", "transform": null }, { "name": "Quantity", "active": true, "dtype": "number", "transform": null }, { "name": "UnitPrice", "active": true, "dtype": "number", "transform": null }, { "name": "DiscountPct", "active": true, "dtype": "number", "transform": null }, { "name": "Currency", "active": true, "dtype": "string", "transform": null }, { "name": "Channel", "active": true, "dtype": "string", "transform": null } ], "sheetNames": null, "sheetColumns": null, "isWildcard": false, "wcPattern": "lib://QXDistributors/Sales_*.csv", "wcGroup": "Sales", "wcExcluded": false, "missing": false, "_rowCount": 110, "previewData": { "columns": [ "SaleID", "SaleDate", "CustomerID", "ProductID", "SalespersonID", "BranchID", "Quantity", "UnitPrice", "DiscountPct", "Currency", "Channel" ], "rows": [ [ "221", "2025-03-28", "60", "17", "6", "1", "14", "51700", "0", "COP", "T" ], [ "222", "2025-03-13", "15", "13", "1", "6", "3", "56400", "0", "COP", "P" ], [ "223", "2025-03-26", "19", "4", "1", "6", "16", "3200", "0", "COP", "T" ], [ "224", "2025-03-23", "54", "38", "3", "1", "3", "64700", "0", "COP", "W" ], [ "225", "2025-03-11", "26", "28", "11", "6", "10", "49500", "15", "COP", "W" ], [ "226", "2025-03-23", "29", "7", "10", "1", "1", "34500", "0", "COP", "W" ], [ "227", "2025-03-31", "34", "31", "2", "7", "22", "46500", "10", "COP", "T" ], [ "228", "2025-03-15", "15", "20", "6", "6", "14", "53300", "5", "COP", "W" ], [ "229", "2025-03-01", "13", "10", "1", "5", "8", "40200", "10", "COP", "T" ], [ "230", "2025-03-27", "19", "4", "9", "3", "2", "3200", "0", "COP", "P" ], [ "231", "2025-03-23", "10", "20", "12", "1", "5", "53300", "0", "COP", "P" ], [ "232", "2025-03-17", "12", "36", "8", "1", "24", "86400", "0", "COP", "P" ], [ "233", "2025-03-09", "54", "11", "2", "4", "24", "70600", "15", "COP", "T" ], [ "234", "2025-03-04", "17", "16", "11", "5", "2", "45000", "0", "COP", "W" ], [ "235", "2025-03-17", "3", "20", "10", "2", "10", "53300", "5", "COP", "W" ], [ "236", "2025-03-12", "16", "38", "9", "8", "23", "64700", "0", "COP", "W" ], [ "237", "2025-03-26", "29", "37", "11", "1", "21", "84500", "0", "COP", "T" ], [ "238", "2025-03-29", "27", "16", "9", "2", "2", "45000", "10", "COP", "T" ], [ "239", "2025-03-12", "18", "34", "11", "7", "4", "54300", "10", "COP", "P" ], [ "240", "2025-03-14", "3", "34", "12", "3", "23", "54300", "10", "COP", "W" ], [ "241", "2025-03-09", "52", "35", "4", "4", "5", "14.41", "0", "USD", "P" ], [ "242", "2025-03-10", "8", "21", "12", "6", "17", "65000", "0", "COP", "T" ], [ "243", "2025-03-06", "13", "5", "2", "5", "2", "3", "10", "USD", "P" ], [ "244", "2025-03-19", "1", "34", "7", "6", "-1", "54300", "15", "COP", "P" ], [ "245", "2025-03-03", "49", "12", "9", "6", "23", "54000", "0", "COP", "P" ], [ "246", "2025-03-02", "18", "6", "3", "4", "12", "40200", "0", "COP", "P" ], [ "247", "2025-03-26", "43", "20", "10", "7", "23", "53300", "0", "COP", "T" ], [ "248", "2025-03-03", "10", "4", "11", "1", "18", "3200", "15", "COP", "P" ], [ "249", "2025-03-15", "56", "12", "12", "5", "19", "54000", "0", "COP", "W" ], [ "250", "2025-03-28", "49", "34", "9", "7", "6", "13.24", "15", "USD", "P" ], [ "251", "2025-03-25", "3", "35", "4", "2", "17", "59100", "0", "COP", "T" ], [ "252", "2025-03-11", "30", "26", "1", "1", "15", "69400", "0", "COP", "P" ], [ "253", "2025-03-29", "23", "5", "5", "4", "8", "12300", "15", "COP", "P" ], [ "254", "2025-03-15", "14", "25", "9", "5", "2", "71300", "15", "COP", "T" ], [ "255", "2025-03-24", "5", "4", "9", "4", "19", "3200", "0", "COP", "W" ], [ "256", "2025-03-23", "27", "14", "10", "1", "14", "23200", "5", "COP", "W" ], [ "257", "2025-03-14", "1", "28", "11", "6", "10", "49500", "0", "COP", "P" ], [ "258", "2025-03-24", "44", "11", "8", "1", "14", "70600", "0", "COP", "P" ], [ "259", "2025-03-26", "39", "11", "5", "5", "15", "70600", "0", "COP", "P" ], [ "260", "2025-03-01", "49", "26", "7", "5", "8", "69400", "0", "COP", "P" ], [ "261", "2025-03-11", "31", "3", "12", "5", "24", "43100", "10", "COP", "P" ], [ "262", "2025-03-19", "56", "35", "11", "6", "12", "14.41", "0", "USD", "W" ], [ "263", "2025-03-03", "4", "27", "6", "2", "21", "70300", "0", "COP", "P" ], [ "264", "2025-03-23", "3", "31", "3", "7", "21", "46500", "10", "COP", "T" ], [ "265", "2025-03-30", "25", "11", "3", "3", "10", "17.22", "0", "USD", "P" ], [ "266", "2025-03-28", "5", "3", "10", "4", "5", "43100", "0", "COP", "P" ], [ "267", "2025-03-10", "999", "35", "10", "5", "15", "59100", "0", "COP", "T" ], [ "268", "2025-03-18", "51", "4", "12", "8", "3", "0.78", "0", "USD", "W" ], [ "269", "2025-03-10", "2", "16", "4", "1", "1", "10.98", "0", "USD", "W" ], [ "270", "2025-03-30", "46", "34", "3", "2", "14", "54300", "0", "COP", "P" ], [ "271", "2025-03-26", "22", "9", "5", "6", "6", "60200", "0", "COP", "W" ], [ "272", "2025-03-24", "58", "37", "5", "7", "15", "84500", "0", "COP", "W" ], [ "273", "2025-03-14", "13", "16", "9", "7", "12", "45000", "0", "COP", "W" ], [ "274", "2025-03-02", "12", "29", "9", "5", "17", "62600", "0", "COP", "W" ], [ "275", "2025-03-24", "8", "11", "1", "2", "5", "70600", "10", "COP", "T" ], [ "276", "2025-03-20", "19", "6", "7", "5", "24", "40200", "0", "COP", "T" ], [ "277", "2025-03-09", "999", "2", "10", "3", "14", "68600", "10", "COP", "T" ], [ "278", "2025-03-01", "28", "16", "1", "3", "19", "45000", "5", "COP", "P" ], [ "279", "2025-03-31", "32", "11", "9", "8", "8", "70600", "0", "COP", "T" ], [ "280", "2025-03-26", "58", "14", "11", "6", "24", "23200", "0", "COP", "P" ], [ "281", "2025-03-02", "27", "28", "3", "3", "20", "49500", "10", "COP", "W" ], [ "282", "2025-03-22", "56", "18", "3", "1", "15", "74300", "0", "COP", "P" ], [ "283", "2025-03-07", "28", "6", "8", "3", "16", "40200", "0", "COP", "P" ], [ "284", "2025-03-24", "48", "5", "9", "8", "24", "12300", "5", "COP", "W" ], [ "285", "2025-03-11", "20", "9", "2", "2", "3", "14.68", "10", "USD", "W" ], [ "286", "2025-03-28", "32", "9", "5", "8", "22", "60200", "15", "COP", "P" ], [ "287", "2025-03-14", "25", "31", "8", "3", "6", "46500", "5", "COP", "W" ], [ "288", "2025-03-20", "10", "9", "4", "4", "9", "60200", "15", "COP", "P" ], [ "289", "2025-03-31", "19", "24", "7", "1", "2", "10.2", "5", "USD", "P" ], [ "290", "2025-03-29", "48", "31", "11", "1", "4", "46500", "0", "COP", "P" ], [ "291", "2025-03-25", "43", "22", "2", "3", "16", "25900", "0", "COP", "T" ], [ "292", "2025-03-12", "57", "31", "12", "2", "23", "46500", "10", "COP", "T" ], [ "293", "2025-03-05", "24", "35", "12", "5", "11", "59100", "5", "COP", "T" ], [ "294", "2025-03-20", "26", "18", "8", "6", "8", "74300", "5", "COP", "P" ], [ "295", "2025-03-24", "24", "6", "4", "2", "9", "40200", "10", "COP", "P" ], [ "296", "2025-03-14", "57", "34", "2", "2", "12", "54300", "0", "COP", "T" ], [ "297", "2025-03-24", "30", "11", "4", "8", "4", "70600", "5", "COP", "T" ], [ "298", "2025-03-26", "7", "23", "7", "2", "14", "88200", "0", "COP", "P" ], [ "299", "2025-03-14", "40", "35", "4", "1", "18", "59100", "15", "COP", "P" ], [ "300", "2025-03-26", "50", "27", "11", "1", "8", "70300", "15", "COP", "P" ], [ "301", "2025-03-16", "53", "36", "8", "2", "13", "86400", "0", "COP", "W" ], [ "302", "2025-03-05", "43", "31", "6", "2", "6", "46500", "10", "COP", "P" ], [ "303", "2025-03-21", "50", "20", "11", "1", "4", "53300", "5", "COP", "P" ], [ "304", "2025-03-18", "34", "34", "9", "8", "19", "54300", "5", "COP", "W" ], [ "305", "2025-03-12", "48", "3", "12", "2", "23", "43100", "0", "COP", "T" ], [ "306", "2025-03-21", "46", "5", "2", "3", "16", "12300", "0", "COP", "T" ], [ "307", "2025-03-31", "2", "15", "7", "3", "24", "80400", "0", "COP", "W" ], [ "308", "2025-03-30", "51", "5", "5", "7", "20", "12300", "10", "COP", "W" ], [ "309", "2025-03-06", "23", "29", "2", "6", "10", "62600", "0", "COP", "W" ], [ "310", "2025-03-01", "32", "27", "12", "1", "19", "70300", "0", "COP", "P" ], [ "311", "2025-03-11", "8", "2", "6", "2", "15", "68600", "15", "COP", "W" ], [ "312", "2025-03-30", "36", "27", "6", "4", "5", "17.15", "15", "USD", "P" ], [ "313", "2025-03-09", "45", "24", "7", "5", "24", "10.2", "0", "USD", "P" ], [ "314", "2025-03-14", "13", "22", "10", "1", "4", "25900", "0", "COP", "W" ], [ "315", "2025-03-10", "22", "12", "10", "7", "22", "54000", "0", "COP", "P" ], [ "316", "2025-03-25", "14", "17", "12", "4", "7", "51700", "0", "COP", "W" ], [ "317", "2025-03-25", "32", "35", "7", "3", "13", "59100", "0", "COP", "T" ], [ "318", "2025-03-30", "55", "35", "6", "6", "22", "59100", "0", "COP", "W" ], [ "319", "2025-03-16", "47", "26", "5", "1", "11", "69400", "0", "COP", "W" ], [ "320", "2025-03-21", "39", "20", "1", "2", "6", "13", "5", "USD", "W" ] ] } } ], "nodes": { "n3": { "id": "n3", "layer": "inline", "label": "tmp_SalesRaw", "customName": "", "x": 40, "y": 83, "srcLibId": null, "srcType": null, "path": "", "dest": "", "desc": "", "fields": "*", "where": "", "devComment": "", "opType": "", "transforms": [], "calcFields": [], "columns": [ { "name": "Dummy", "active": true, "dtype": "string", "transform": null, "alias": null }, { "name": "SaleID", "active": true, "dtype": "string", "transform": null, "alias": null, "_propOriginNodeId": "n7", "_loopSync": true }, { "name": "SaleDate", "active": true, "dtype": "string", "transform": null, "alias": null, "_propOriginNodeId": "n7", "_loopSync": true }, { "name": "CustomerID", "active": true, "dtype": "string", "transform": null, "alias": null, "_propOriginNodeId": "n7", "_loopSync": true }, { "name": "ProductID", "active": true, "dtype": "string", "transform": null, "alias": null, "_propOriginNodeId": "n7", "_loopSync": true }, { "name": "SalespersonID", "active": true, "dtype": "string", "transform": null, "alias": null, "_propOriginNodeId": "n7", "_loopSync": true }, { "name": "BranchID", "active": true, "dtype": "string", "transform": null, "alias": null, "_propOriginNodeId": "n7", "_loopSync": true }, { "name": "Quantity", "active": true, "dtype": "string", "transform": null, "alias": null, "_propOriginNodeId": "n7", "_loopSync": true }, { "name": "UnitPrice", "active": true, "dtype": "string", "transform": null, "alias": null, "_propOriginNodeId": "n7", "_loopSync": true }, { "name": "DiscountPct", "active": true, "dtype": "string", "transform": null, "alias": null, "_propOriginNodeId": "n7", "_loopSync": true }, { "name": "Currency", "active": true, "dtype": "string", "transform": null, "alias": null, "_propOriginNodeId": "n7", "_loopSync": true }, { "name": "Channel", "active": true, "dtype": "string", "transform": null, "alias": null, "_propOriginNodeId": "n7", "_loopSync": true }, { "name": "SourceFile", "active": true, "dtype": "string", "alias": null, "_propOriginNodeId": "n7", "_loopSync": true } ], "showColumns": false, "joinSrc": "", "joinFields": "*", "joinType": "LEFT JOIN", "joinMode": "JOIN", "joinResultResident": true, "joinResultName": "", "forceInlineIds": [], "ctAttrField": "", "ctDataField": "", "ctNPrefix": 1, "mapKey": "", "mapVal": "", "mapDef": "'N/A'", "mapSrcId": "", "mapSrcCol1": "", "mapSrcCol2": "", "isWildcard": false, "wcPattern": "", "wildFields": "*", "wildWhere": "", "inlineDummyWhere": true, "srcByVar": false, "srcVarExpr": "", "concatIntoName": "", "residentByName": false, "residentFromName": "", "joinIntoName": "", "joinIntoType": "LEFT JOIN", "xlsxHeaderRow": 1, "storeResult": true, "missing": false, "required": false, "disabled": false, "dropTableIds": [], "dropFieldIds": [], "dropByNameText": "", "dropFieldsByNameText": "", "traceMsg": "", "switchExpr": "", "renameOps": [], "divisorFileName": "", "imMatchField": "", "imStartCol": "", "imEndCol": "", "imExtraKeys": "", "letSetOps": [], "qualifyMode": "QUALIFY", "qualifyUseWildcard": true, "qualifyFields": [], "loopKind": "list", "loopVarName": "vItem", "loopListValues": "", "loopFileListPath": "", "loopNumericMode": "plain", "loopStart": "1", "loopEnd": "10", "loopStep": "", "loopFieldValueField": "", "loopFieldValueVar": "vValue", "loopFieldValueTotalVar": "vTotal", "loopPeekTable": "", "loopPeekPairs": [], "loopPeekTotalVar": "vTotal", "loopBodyProjectId": null, "ifCondition": "", "autocalFieldMap": {}, "autocalFields": [ "year", "month", "yearmonth", "quarter", "yearquarter", "week", "date" ], "libraryId": null, "routineName": null, "args": [], "rawScriptText": "", "inlineCols": [ "Dummy" ], "inlineRows": [], "_reLine": 5 }, "n4": { "id": "n4", "layer": "loop", "label": "Loop", "customName": "", "x": 282, "y": 80, "srcLibId": null, "srcType": null, "path": "", "dest": "", "desc": "", "fields": "*", "where": "", "devComment": "", "opType": "", "transforms": [], "calcFields": [], "columns": [], "showColumns": false, "joinSrc": "", "joinFields": "*", "joinType": "LEFT JOIN", "joinMode": "JOIN", "joinResultResident": true, "joinResultName": "", "forceInlineIds": [], "ctAttrField": "", "ctDataField": "", "ctNPrefix": 1, "mapKey": "", "mapVal": "", "mapDef": "'N/A'", "mapSrcId": "", "mapSrcCol1": "", "mapSrcCol2": "", "isWildcard": false, "wcPattern": "", "wildFields": "*", "wildWhere": "", "inlineDummyWhere": false, "srcByVar": false, "srcVarExpr": "", "concatIntoName": "", "residentByName": false, "residentFromName": "", "joinIntoName": "", "joinIntoType": "LEFT JOIN", "xlsxHeaderRow": 1, "storeResult": false, "missing": false, "required": false, "disabled": false, "dropTableIds": [], "dropFieldIds": [], "dropByNameText": "", "dropFieldsByNameText": "", "traceMsg": "", "switchExpr": "", "renameOps": [], "divisorFileName": "", "imMatchField": "", "imStartCol": "", "imEndCol": "", "imExtraKeys": "", "letSetOps": [], "qualifyMode": "QUALIFY", "qualifyUseWildcard": true, "qualifyFields": [], "loopKind": "filelist", "loopVarName": "vFile", "loopListValues": "", "loopFileListPath": "$(vPathRaw)Sales_*.csv", "loopNumericMode": "plain", "loopStart": "1", "loopEnd": "10", "loopStep": "", "loopFieldValueField": "", "loopFieldValueVar": "vValue", "loopFieldValueTotalVar": "vTotal", "loopPeekTable": "", "loopPeekPairs": [], "loopPeekTotalVar": "vTotal", "loopBodyProjectId": "p5", "ifCondition": "", "autocalFieldMap": {}, "autocalFields": [ "year", "month", "yearmonth", "quarter", "yearquarter", "week", "date" ], "libraryId": null, "routineName": null, "args": [], "rawScriptText": "", "_reLine": 10 }, "n9": { "id": "n9", "layer": "drop", "label": "Drop", "customName": "", "x": 462, "y": 42.5, "srcLibId": null, "srcType": null, "path": "", "dest": "", "desc": "", "fields": "*", "where": "", "devComment": "", "opType": "", "transforms": [], "calcFields": [], "columns": [], "showColumns": false, "joinSrc": "", "joinFields": "*", "joinType": "LEFT JOIN", "joinMode": "JOIN", "joinResultResident": true, "joinResultName": "", "forceInlineIds": [], "ctAttrField": "", "ctDataField": "", "ctNPrefix": 1, "mapKey": "", "mapVal": "", "mapDef": "'N/A'", "mapSrcId": "", "mapSrcCol1": "", "mapSrcCol2": "", "isWildcard": false, "wcPattern": "", "wildFields": "*", "wildWhere": "", "inlineDummyWhere": false, "srcByVar": false, "srcVarExpr": "", "concatIntoName": "", "residentByName": false, "residentFromName": "", "joinIntoName": "", "joinIntoType": "LEFT JOIN", "xlsxHeaderRow": 1, "storeResult": true, "missing": false, "required": false, "disabled": false, "dropTableIds": [], "dropFieldIds": [ "n3::Dummy" ], "dropByNameText": "", "dropFieldsByNameText": "", "traceMsg": "", "switchExpr": "", "renameOps": [], "divisorFileName": "", "imMatchField": "", "imStartCol": "", "imEndCol": "", "imExtraKeys": "", "letSetOps": [], "qualifyMode": "QUALIFY", "qualifyUseWildcard": true, "qualifyFields": [], "loopKind": "list", "loopVarName": "vItem", "loopListValues": "", "loopFileListPath": "", "loopNumericMode": "plain", "loopStart": "1", "loopEnd": "10", "loopStep": "", "loopFieldValueField": "", "loopFieldValueVar": "vValue", "loopFieldValueTotalVar": "vTotal", "loopPeekTable": "", "loopPeekPairs": [], "loopPeekTotalVar": "vTotal", "loopBodyProjectId": null, "ifCondition": "", "autocalFieldMap": {}, "autocalFields": [ "year", "month", "yearmonth", "quarter", "yearquarter", "week", "date" ], "libraryId": null, "routineName": null, "args": [], "rawScriptText": "", "_reLine": 30 }, "n11": { "id": "n11", "layer": "letset", "label": "Let/Set", "customName": "", "x": 516, "y": 42.5, "srcLibId": null, "srcType": null, "path": "", "dest": "", "desc": "", "fields": "*", "where": "", "devComment": "", "opType": "", "transforms": [], "calcFields": [], "columns": [], "showColumns": false, "joinSrc": "", "joinFields": "*", "joinType": "LEFT JOIN", "joinMode": "JOIN", "joinResultResident": true, "joinResultName": "", "forceInlineIds": [], "ctAttrField": "", "ctDataField": "", "ctNPrefix": 1, "mapKey": "", "mapVal": "", "mapDef": "'N/A'", "mapSrcId": "", "mapSrcCol1": "", "mapSrcCol2": "", "isWildcard": false, "wcPattern": "", "wildFields": "*", "wildWhere": "", "inlineDummyWhere": false, "srcByVar": false, "srcVarExpr": "", "concatIntoName": "", "residentByName": false, "residentFromName": "", "joinIntoName": "", "joinIntoType": "LEFT JOIN", "xlsxHeaderRow": 1, "storeResult": false, "missing": false, "required": false, "disabled": false, "dropTableIds": [], "dropFieldIds": [], "dropByNameText": "", "dropFieldsByNameText": "", "traceMsg": "", "switchExpr": "", "renameOps": [], "divisorFileName": "", "imMatchField": "", "imStartCol": "", "imEndCol": "", "imExtraKeys": "", "letSetOps": [ { "name": "vSalesRawRows", "expr": "NoOfRows('tmp_SalesRaw')", "kind": "LET" } ], "qualifyMode": "QUALIFY", "qualifyUseWildcard": true, "qualifyFields": [], "loopKind": "list", "loopVarName": "vItem", "loopListValues": "", "loopFileListPath": "", "loopNumericMode": "plain", "loopStart": "1", "loopEnd": "10", "loopStep": "", "loopFieldValueField": "", "loopFieldValueVar": "vValue", "loopFieldValueTotalVar": "vTotal", "loopPeekTable": "", "loopPeekPairs": [], "loopPeekTotalVar": "vTotal", "loopBodyProjectId": null, "ifCondition": "", "autocalFieldMap": {}, "autocalFields": [ "year", "month", "yearmonth", "quarter", "yearquarter", "week", "date" ], "libraryId": null, "routineName": null, "args": [], "rawScriptText": "", "_reLine": 32 }, "n13": { "id": "n13", "layer": "trace", "label": "Trace", "customName": "", "x": 570, "y": 42.5, "srcLibId": null, "srcType": null, "path": "", "dest": "", "desc": "", "fields": "*", "where": "", "devComment": "", "opType": "", "transforms": [], "calcFields": [], "columns": [], "showColumns": false, "joinSrc": "", "joinFields": "*", "joinType": "LEFT JOIN", "joinMode": "JOIN", "joinResultResident": true, "joinResultName": "", "forceInlineIds": [], "ctAttrField": "", "ctDataField": "", "ctNPrefix": 1, "mapKey": "", "mapVal": "", "mapDef": "'N/A'", "mapSrcId": "", "mapSrcCol1": "", "mapSrcCol2": "", "isWildcard": false, "wcPattern": "", "wildFields": "*", "wildWhere": "", "inlineDummyWhere": false, "srcByVar": false, "srcVarExpr": "", "concatIntoName": "", "residentByName": false, "residentFromName": "", "joinIntoName": "", "joinIntoType": "LEFT JOIN", "xlsxHeaderRow": 1, "storeResult": false, "missing": false, "required": false, "disabled": false, "dropTableIds": [], "dropFieldIds": [], "dropByNameText": "", "dropFieldsByNameText": "", "traceMsg": "Sales rows read from the monthly files: $(vSalesRawRows)", "switchExpr": "", "renameOps": [], "divisorFileName": "", "imMatchField": "", "imStartCol": "", "imEndCol": "", "imExtraKeys": "", "letSetOps": [], "qualifyMode": "QUALIFY", "qualifyUseWildcard": true, "qualifyFields": [], "loopKind": "list", "loopVarName": "vItem", "loopListValues": "", "loopFileListPath": "", "loopNumericMode": "plain", "loopStart": "1", "loopEnd": "10", "loopStep": "", "loopFieldValueField": "", "loopFieldValueVar": "vValue", "loopFieldValueTotalVar": "vTotal", "loopPeekTable": "", "loopPeekPairs": [], "loopPeekTotalVar": "vTotal", "loopBodyProjectId": null, "ifCondition": "", "autocalFieldMap": {}, "autocalFields": [ "year", "month", "yearmonth", "quarter", "yearquarter", "week", "date" ], "libraryId": null, "routineName": null, "args": [], "rawScriptText": "", "_reLine": 33 }, "n15": { "id": "n15", "layer": "divisor", "label": "Script Split", "customName": "", "x": 12, "y": 46, "srcLibId": null, "srcType": null, "path": "", "dest": "", "desc": "", "fields": "*", "where": "", "devComment": "", "opType": "", "transforms": [], "calcFields": [], "columns": [], "showColumns": false, "joinSrc": "", "joinFields": "*", "joinType": "LEFT JOIN", "joinMode": "JOIN", "joinResultResident": true, "joinResultName": "", "forceInlineIds": [], "ctAttrField": "", "ctDataField": "", "ctNPrefix": 1, "mapKey": "", "mapVal": "", "mapDef": "'N/A'", "mapSrcId": "", "mapSrcCol1": "", "mapSrcCol2": "", "isWildcard": false, "wcPattern": "", "wildFields": "*", "wildWhere": "", "inlineDummyWhere": false, "srcByVar": false, "srcVarExpr": "", "concatIntoName": "", "residentByName": false, "residentFromName": "", "joinIntoName": "", "joinIntoType": "LEFT JOIN", "xlsxHeaderRow": 1, "storeResult": false, "missing": false, "required": false, "disabled": false, "dropTableIds": [], "dropFieldIds": [], "dropByNameText": "", "dropFieldsByNameText": "", "traceMsg": "", "switchExpr": "", "renameOps": [], "divisorFileName": "Flow_1", "imMatchField": "", "imStartCol": "", "imEndCol": "", "imExtraKeys": "", "letSetOps": [], "qualifyMode": "QUALIFY", "qualifyUseWildcard": true, "qualifyFields": [], "loopKind": "list", "loopVarName": "vItem", "loopListValues": "", "loopFileListPath": "", "loopNumericMode": "plain", "loopStart": "1", "loopEnd": "10", "loopStep": "", "loopFieldValueField": "", "loopFieldValueVar": "vValue", "loopFieldValueTotalVar": "vTotal", "loopPeekTable": "", "loopPeekPairs": [], "loopPeekTotalVar": "vTotal", "loopBodyProjectId": null, "ifCondition": "", "autocalFieldMap": {}, "autocalFields": [ "year", "month", "yearmonth", "quarter", "yearquarter", "week", "date" ], "libraryId": null, "routineName": null, "args": [], "rawScriptText": "" } }, "conns": [ { "from": "n3", "to": "n4", "id": "c8" }, { "from": "n4", "to": "n9", "id": "c10" }, { "from": "n9", "to": "n11", "id": "c12" }, { "from": "n11", "to": "n13", "id": "c14" }, { "from": "n15", "to": "n3", "id": "c16" } ], "zoom": 1, "chkSweepDisabled": false, "keyMode": "advanced", "params": { "mapPfx": "map_", "inlPfx": "inl_", "skPfx": "%SK_", "ckPfx": "%CK_", "dateFmt": "YYYY-MM-DD", "tsFmt": "YYYY-MM-DD hh:mm:ss", "timeFmt": "hh:mm:ss", "dec": ".", "thou": ",", "moneyDec": ".", "moneyThou": ",", "moneyFmt": "$ #,##0.00;-$ #,##0.00", "firstWeekDay": "0", "brokenWeeks": "1", "referenceDay": "4", "firstMonthOfYear": "1", "monthNames": "Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec", "longMonthNames": "January;February;March;April;May;June;July;August;September;October;November;December", "dayNames": "Mon;Tue;Wed;Thu;Fri;Sat;Sun", "longDayNames": "Monday;Tuesday;Wednesday;Thursday;Friday;Saturday;Sunday" }, "txfVarName": "vTxfPath" }, "p5": { "id": "p5", "name": "Loop body", "author": "", "desc": "", "rootPath": "lib://QVD/", "txfPath": "lib://Transformed/", "qvsSubfolder": "_QVS", "busPath": "", "srcPaths": [], "envProfiles": [ { "id": "env6", "name": "Default", "srcPaths": [], "exportDirLabel": "" } ], "activeEnvProfileId": "env6", "vars": [], "header": "/*----------------------------------------------------------------------------------------\n\tDescription [{{layer}}]:\n\t\t{{description}}\n\t-------------------------------------------------------------------------------------\n\tAuthor:\t{{author}} - {{role}}\n\tDate:\t[{{date}}]\n\t-------------------------------------------------------------------------------------\n\tChanges\n\t-------------------------------------------------------------------------------------\n\tAuthor\t\tDate\t\tDetail\n\t-------------------------------------------------------------------------------------\n\n\t-------------------------------------------------------------------------------------\n\tCopyright © {{project}}.\n\tQ-Expert Qlik Developer Framework. www.qfabrica.com\n----------------------------------------------------------------------------------------*/", "library": [], "nodes": { "n7": { "id": "n7", "layer": "raw", "label": "vFile", "customName": "", "x": 60, "y": 60, "srcLibId": null, "srcType": "txt", "path": "", "dest": "", "desc": "", "fields": "*", "where": "", "devComment": "", "opType": "", "transforms": [ { "fn": "reversed", "group": "reversed", "expr": "FileName()", "alias": "SourceFile", "params": { "newCol": true } } ], "calcFields": [], "columns": [ { "name": "SaleID", "active": true, "dtype": "string", "transform": null, "alias": null }, { "name": "SaleDate", "active": true, "dtype": "string", "transform": null, "alias": null }, { "name": "CustomerID", "active": true, "dtype": "string", "transform": null, "alias": null }, { "name": "ProductID", "active": true, "dtype": "string", "transform": null, "alias": null }, { "name": "SalespersonID", "active": true, "dtype": "string", "transform": null, "alias": null }, { "name": "BranchID", "active": true, "dtype": "string", "transform": null, "alias": null }, { "name": "Quantity", "active": true, "dtype": "string", "transform": null, "alias": null }, { "name": "UnitPrice", "active": true, "dtype": "string", "transform": null, "alias": null }, { "name": "DiscountPct", "active": true, "dtype": "string", "transform": null, "alias": null }, { "name": "Currency", "active": true, "dtype": "string", "transform": null, "alias": null }, { "name": "Channel", "active": true, "dtype": "string", "transform": null, "alias": null } ], "showColumns": false, "joinSrc": "", "joinFields": "*", "joinType": "LEFT JOIN", "joinMode": "JOIN", "joinResultResident": true, "joinResultName": "", "forceInlineIds": [], "ctAttrField": "", "ctDataField": "", "ctNPrefix": 1, "mapKey": "", "mapVal": "", "mapDef": "'N/A'", "mapSrcId": "", "mapSrcCol1": "", "mapSrcCol2": "", "isWildcard": false, "wcPattern": "", "wildFields": "*", "wildWhere": "", "inlineDummyWhere": false, "srcByVar": true, "srcVarExpr": "$(vFile)", "concatIntoName": "tmp_SalesRaw", "residentByName": false, "residentFromName": "", "joinIntoName": "", "joinIntoType": "LEFT JOIN", "xlsxHeaderRow": 1, "storeResult": false, "missing": false, "required": false, "disabled": false, "dropTableIds": [], "dropFieldIds": [], "dropByNameText": "", "dropFieldsByNameText": "", "traceMsg": "", "switchExpr": "", "renameOps": [], "divisorFileName": "", "imMatchField": "", "imStartCol": "", "imEndCol": "", "imExtraKeys": "", "letSetOps": [], "qualifyMode": "QUALIFY", "qualifyUseWildcard": true, "qualifyFields": [], "loopKind": "list", "loopVarName": "vItem", "loopListValues": "", "loopFileListPath": "", "loopNumericMode": "plain", "loopStart": "1", "loopEnd": "10", "loopStep": "", "loopFieldValueField": "", "loopFieldValueVar": "vValue", "loopFieldValueTotalVar": "vTotal", "loopPeekTable": "", "loopPeekPairs": [], "loopPeekTotalVar": "vTotal", "loopBodyProjectId": null, "ifCondition": "", "autocalFieldMap": {}, "autocalFields": [ "year", "month", "yearmonth", "quarter", "yearquarter", "week", "date" ], "libraryId": null, "routineName": null, "args": [], "rawScriptText": "", "_reSynthSrc": true, "delim": ",", "csvUtf8": true, "csvMsq": true, "useWildcard": false, "_reLine": 12 } }, "conns": [], "zoom": 1, "chkSweepDisabled": false, "keyMode": "advanced", "isLoopBody": true, "parentProjectId": "p1" } } }