{ "version": 5, "savedAt": "2026-11-01T23:14:43.040Z", "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": 195, "srcLibId": null, "srcType": null, "path": "", "dest": "", "desc": "", "fields": "*", "where": "", "devComment": "", "opType": "", "transforms": [], "calcFields": [], "columns": [ { "name": "Dummy", "active": true, "dtype": "string", "transform": null, "alias": null, "_cid": "k_mvyg68lb79" }, { "name": "SaleID", "active": true, "dtype": "string", "transform": null, "alias": null, "_propOriginNodeId": "n7", "_loopSync": true, "_cid": "k_mvyg68m4146" }, { "name": "SaleDate", "active": true, "dtype": "string", "transform": null, "alias": null, "_propOriginNodeId": "n7", "_loopSync": true, "_cid": "k_mvyg68m5147" }, { "name": "CustomerID", "active": true, "dtype": "string", "transform": null, "alias": null, "_propOriginNodeId": "n7", "_loopSync": true, "_cid": "k_mvyg68m5148" }, { "name": "ProductID", "active": true, "dtype": "string", "transform": null, "alias": null, "_propOriginNodeId": "n7", "_loopSync": true, "_cid": "k_mvyg68m5149" }, { "name": "SalespersonID", "active": true, "dtype": "string", "transform": null, "alias": null, "_propOriginNodeId": "n7", "_loopSync": true, "_cid": "k_mvyg68m5150" }, { "name": "BranchID", "active": true, "dtype": "string", "transform": null, "alias": null, "_propOriginNodeId": "n7", "_loopSync": true, "_cid": "k_mvyg68m5151" }, { "name": "Quantity", "active": true, "dtype": "string", "transform": null, "alias": null, "_propOriginNodeId": "n7", "_loopSync": true, "_cid": "k_mvyg68m5152" }, { "name": "UnitPrice", "active": true, "dtype": "string", "transform": null, "alias": null, "_propOriginNodeId": "n7", "_loopSync": true, "_cid": "k_mvyg68m5153" }, { "name": "DiscountPct", "active": true, "dtype": "string", "transform": null, "alias": null, "_propOriginNodeId": "n7", "_loopSync": true, "_cid": "k_mvyg68m5154" }, { "name": "Currency", "active": true, "dtype": "string", "transform": null, "alias": null, "_propOriginNodeId": "n7", "_loopSync": true, "_cid": "k_mvyg68m5155" }, { "name": "Channel", "active": true, "dtype": "string", "transform": null, "alias": null, "_propOriginNodeId": "n7", "_loopSync": true, "_cid": "k_mvyg68m5156" }, { "name": "SourceFile", "active": true, "dtype": "string", "alias": null, "_propOriginNodeId": "n7", "_loopSync": true, "_cid": "k_mvyg68m5157" } ], "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": 322, "y": 192, "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": 502, "y": 154.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": 556, "y": 154.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": 610, "y": 154.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": "raw", "label": "tmp_Parameter", "customName": "", "x": 656, "y": 195, "srcLibId": null, "srcType": "txt", "path": "$(vPathRaw)Parameters.txt", "dest": "", "desc": "", "fields": "*", "where": "", "devComment": "", "opType": "", "transforms": [], "calcFields": [], "columns": [ { "name": "Parameter", "active": true, "dtype": "string", "transform": null, "alias": null }, { "name": "Value", "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": 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": "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": "", "csvUtf8": true, "csvMsq": true, "noConcatenate": false, "useWildcard": false, "_reLine": 39 }, "n17": { "id": "n17", "layer": "letset", "label": "Let/Set_2", "customName": "", "x": 836, "y": 155, "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": "vCreditThreshold", "expr": "Lookup('Value', 'Parameter', 'CreditThreshold', 'tmp_Parameter')", "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": 43 }, "n19": { "id": "n19", "layer": "drop", "label": "Drop_2", "customName": "", "x": 890, "y": 155, "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": [ "n15" ], "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": "", "_reLine": 45 }, "n21": { "id": "n21", "layer": "map", "label": "map_DocType", "customName": "", "x": 322, "y": 1091, "srcLibId": null, "srcType": null, "path": "", "dest": "", "desc": "", "fields": "*", "where": "", "devComment": "", "opType": "MAPPING", "transforms": [], "calcFields": [], "columns": [], "showColumns": false, "joinSrc": "", "joinFields": "*", "joinType": "LEFT JOIN", "joinMode": "JOIN", "joinResultResident": true, "joinResultName": "", "forceInlineIds": [], "ctAttrField": "", "ctDataField": "", "ctNPrefix": 1, "mapKey": "DocType", "mapVal": "DocTypeName", "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": "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": "", "_reMapScriptName": "map_DocType", "_reLine": 47 }, "n22": { "id": "n22", "layer": "inline", "label": "map_DocType_Src", "customName": "", "x": 40, "y": 1091, "srcLibId": null, "srcType": null, "path": "", "dest": "", "desc": "", "fields": "*", "where": "", "devComment": "", "opType": "", "transforms": [], "calcFields": [], "columns": [ { "name": "DocType", "active": true, "dtype": "string", "transform": null, "alias": null }, { "name": "DocTypeName", "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": 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": [ "DocType", "DocTypeName" ], "inlineRows": [ [ "NIT", "Company" ], [ "CC", "Person" ] ], "synthStage": true }, "n24": { "id": "n24", "layer": "map", "label": "map_CustomerStatus", "customName": "", "x": 322, "y": 1271, "srcLibId": null, "srcType": null, "path": "", "dest": "", "desc": "", "fields": "*", "where": "", "devComment": "", "opType": "MAPPING", "transforms": [], "calcFields": [], "columns": [], "showColumns": false, "joinSrc": "", "joinFields": "*", "joinType": "LEFT JOIN", "joinMode": "JOIN", "joinResultResident": true, "joinResultName": "", "forceInlineIds": [], "ctAttrField": "", "ctDataField": "", "ctNPrefix": 1, "mapKey": "Status", "mapVal": "CustomerStatus", "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": "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": "", "_reMapScriptName": "map_CustomerStatus", "_reLine": 54 }, "n25": { "id": "n25", "layer": "inline", "label": "map_CustomerStatus_Src", "customName": "", "x": 40, "y": 1271, "srcLibId": null, "srcType": null, "path": "", "dest": "", "desc": "", "fields": "*", "where": "", "devComment": "", "opType": "", "transforms": [], "calcFields": [], "columns": [ { "name": "Status", "active": true, "dtype": "string", "transform": null, "alias": null }, { "name": "CustomerStatus", "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": 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": [ "Status", "CustomerStatus" ], "inlineRows": [ [ "A", "Active" ], [ "I", "Inactive" ], [ "B", "Blocked" ] ], "synthStage": true }, "n27": { "id": "n27", "layer": "map", "label": "map_ChannelName", "customName": "", "x": 322, "y": 1451, "srcLibId": null, "srcType": null, "path": "", "dest": "", "desc": "", "fields": "*", "where": "", "devComment": "", "opType": "MAPPING", "transforms": [], "calcFields": [], "columns": [], "showColumns": false, "joinSrc": "", "joinFields": "*", "joinType": "LEFT JOIN", "joinMode": "JOIN", "joinResultResident": true, "joinResultName": "", "forceInlineIds": [], "ctAttrField": "", "ctDataField": "", "ctNPrefix": 1, "mapKey": "Channel", "mapVal": "ChannelName", "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": "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": "", "_reMapScriptName": "map_ChannelName", "_reLine": 62 }, "n28": { "id": "n28", "layer": "inline", "label": "map_ChannelName_Src", "customName": "", "x": 40, "y": 1451, "srcLibId": null, "srcType": null, "path": "", "dest": "", "desc": "", "fields": "*", "where": "", "devComment": "", "opType": "", "transforms": [], "calcFields": [], "columns": [ { "name": "Channel", "active": true, "dtype": "string", "transform": null, "alias": null }, { "name": "ChannelName", "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": 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": [ "Channel", "ChannelName" ], "inlineRows": [ [ "P", "Phone" ], [ "T", "In store" ], [ "W", "Web" ] ], "synthStage": true }, "n30": { "id": "n30", "layer": "map", "label": "map_BrandName", "customName": "", "x": 40, "y": 81, "srcLibId": null, "srcType": "txt", "path": "$(vPathRaw)Brands.txt", "dest": "", "desc": "", "fields": "*", "where": "", "devComment": "", "opType": "MAPPING", "transforms": [], "calcFields": [], "columns": [], "showColumns": false, "joinSrc": "", "joinFields": "*", "joinType": "LEFT JOIN", "joinMode": "JOIN", "joinResultResident": true, "joinResultName": "", "forceInlineIds": [], "ctAttrField": "", "ctDataField": "", "ctNPrefix": 1, "mapKey": "BrandID", "mapVal": "BrandName", "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": "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": "", "_reMapScriptName": "map_BrandName", "delim": "|", "csvUtf8": true, "csvMsq": true, "_reLine": 70 }, "n31": { "id": "n31", "layer": "map", "label": "map_Holiday", "customName": "", "x": 40, "y": 293, "srcLibId": null, "srcType": "txt", "path": "$(vPathRaw)Holidays.csv", "dest": "", "desc": "", "fields": "*", "where": "", "devComment": "", "opType": "MAPPING", "transforms": [], "calcFields": [], "columns": [], "showColumns": false, "joinSrc": "", "joinFields": "*", "joinType": "LEFT JOIN", "joinMode": "JOIN", "joinResultResident": true, "joinResultName": "", "forceInlineIds": [], "ctAttrField": "", "ctDataField": "", "ctNPrefix": 1, "mapKey": "Num(Date#(HolidayDate, 'YYYY-MM-DD')) AS HolidayDate", "mapVal": "HolidayName", "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": "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": "", "_reMapScriptName": "map_Holiday", "distinct": true, "delim": ",", "csvUtf8": true, "csvMsq": true, "_reLine": 74 }, "n32": { "id": "n32", "layer": "qualify", "label": "Qualify", "customName": "", "x": 220, "y": 247, "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": "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": 85 }, "n34": { "id": "n34", "layer": "qualify", "label": "Qualify_2", "customName": "", "x": 274, "y": 247, "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": "UNQUALIFY", "qualifyUseWildcard": false, "qualifyFields": [ "CustomerID", "ProductID", "SalespersonID", "BranchID", "CategoryID", "BrandID", "DocNumber" ], "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": 86 }, "n36": { "id": "n36", "layer": "raw", "label": "tmp_CustomerRaw", "customName": "", "x": 322, "y": 548, "srcLibId": null, "srcType": "txt", "path": "$(vPathRaw)Customers.csv", "dest": "", "desc": "", "fields": "*", "where": "", "devComment": "", "opType": "", "transforms": [], "calcFields": [], "columns": [ { "name": "CustomerID", "active": true, "dtype": "string", "transform": null, "alias": null, "_cid": "k_mvyg68l51" }, { "name": "CustomerName", "active": true, "dtype": "string", "transform": null, "alias": null, "_cid": "k_mvyg68l52" }, { "name": "DocType", "active": true, "dtype": "string", "transform": null, "alias": null, "_cid": "k_mvyg68l53" }, { "name": "DocNumber", "active": true, "dtype": "string", "transform": null, "alias": null, "_cid": "k_mvyg68l54" }, { "name": "City", "active": true, "dtype": "string", "transform": null, "alias": null, "_cid": "k_mvyg68l55" }, { "name": "Segment", "active": true, "dtype": "string", "transform": null, "alias": null, "_cid": "k_mvyg68l56" }, { "name": "SignupDate", "active": true, "dtype": "string", "transform": null, "alias": null, "_cid": "k_mvyg68l57" }, { "name": "Status", "active": true, "dtype": "string", "transform": null, "alias": null, "_cid": "k_mvyg68l58" }, { "name": "CreditLimit", "active": true, "dtype": "string", "transform": null, "alias": null, "_cid": "k_mvyg68l59" } ], "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": "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": "", "delim": ",", "csvUtf8": true, "csvMsq": true, "noConcatenate": false, "useWildcard": false, "_reLine": 88 }, "n38": { "id": "n38", "layer": "raw", "label": "tmp_ProductRaw", "customName": "", "x": 938, "y": 548, "srcLibId": null, "srcType": "txt", "path": "$(vPathRaw)Products.csv", "dest": "", "desc": "", "fields": "*", "where": "", "devComment": "", "opType": "", "transforms": [], "calcFields": [], "columns": [ { "name": "ProductID", "active": true, "dtype": "string", "transform": null, "alias": null, "_cid": "k_mvyg68l835" }, { "name": "SKU", "active": true, "dtype": "string", "transform": null, "alias": null, "_cid": "k_mvyg68l836" }, { "name": "ProductName", "active": true, "dtype": "string", "transform": null, "alias": null, "_cid": "k_mvyg68l837" }, { "name": "CategoryID", "active": true, "dtype": "string", "transform": null, "alias": null, "_cid": "k_mvyg68l838" }, { "name": "BrandID", "active": true, "dtype": "string", "transform": null, "alias": null, "_cid": "k_mvyg68l839" }, { "name": "ListPrice", "active": true, "dtype": "string", "transform": null, "alias": null, "_cid": "k_mvyg68l840" }, { "name": "UnitCost", "active": true, "dtype": "string", "transform": null, "alias": null, "_cid": "k_mvyg68l841" }, { "name": "UnitOfMeasure", "active": true, "dtype": "string", "transform": null, "alias": null, "_cid": "k_mvyg68l842" }, { "name": "Status", "active": true, "dtype": "string", "transform": null, "alias": null, "_cid": "k_mvyg68l843" } ], "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": "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": "", "delim": ",", "csvUtf8": true, "csvMsq": true, "noConcatenate": false, "useWildcard": false, "_reLine": 92 }, "n39": { "id": "n39", "layer": "raw", "label": "tmp_SalespersonRaw", "customName": "", "x": 322, "y": 377, "srcLibId": null, "srcType": "txt", "path": "$(vPathRaw)Salespeople.csv", "dest": "", "desc": "", "fields": "*", "where": "", "devComment": "", "opType": "", "transforms": [], "calcFields": [], "columns": [ { "name": "SalespersonID", "active": true, "dtype": "string", "transform": null, "alias": null, "_cid": "k_mvyg68l844" }, { "name": "SalespersonName", "active": true, "dtype": "string", "transform": null, "alias": null, "_cid": "k_mvyg68l845" }, { "name": "BranchID", "active": true, "dtype": "string", "transform": null, "alias": null, "_cid": "k_mvyg68l846" }, { "name": "HireDate", "active": true, "dtype": "string", "transform": null, "alias": null, "_cid": "k_mvyg68l847" }, { "name": "MonthlyTarget", "active": true, "dtype": "string", "transform": null, "alias": null, "_cid": "k_mvyg68l848" } ], "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": "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": "", "delim": ",", "csvUtf8": true, "csvMsq": true, "noConcatenate": false, "useWildcard": false, "_reLine": 96 }, "n40": { "id": "n40", "layer": "raw", "label": "tmp_BranchRaw", "customName": "", "x": 40, "y": 459, "srcLibId": null, "srcType": "txt", "path": "$(vPathRaw)Branches.csv", "dest": "", "desc": "", "fields": "*", "where": "", "devComment": "", "opType": "", "transforms": [], "calcFields": [], "columns": [ { "name": "BranchID", "active": true, "dtype": "string", "transform": null, "alias": null, "_cid": "k_mvyg68l849" }, { "name": "BranchName", "active": true, "dtype": "string", "transform": null, "alias": null, "_cid": "k_mvyg68l850" }, { "name": "Region", "active": true, "dtype": "string", "transform": null, "alias": null, "_cid": "k_mvyg68l851" }, { "name": "City", "active": true, "dtype": "string", "transform": null, "alias": null, "_cid": "k_mvyg68l852" }, { "name": "Format", "active": true, "dtype": "string", "transform": null, "alias": null, "_cid": "k_mvyg68l853" } ], "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": "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": "", "delim": ",", "csvUtf8": true, "csvMsq": true, "noConcatenate": false, "useWildcard": false, "_reLine": 100 }, "n41": { "id": "n41", "layer": "raw", "label": "tmp_CategoryRaw", "customName": "", "x": 40, "y": 637, "srcLibId": null, "srcType": "txt", "path": "$(vPathRaw)Categories.csv", "dest": "", "desc": "", "fields": "*", "where": "", "devComment": "", "opType": "", "transforms": [], "calcFields": [], "columns": [ { "name": "CategoryID", "active": true, "dtype": "string", "transform": null, "alias": null, "_cid": "k_mvyg68l829" }, { "name": "CategoryName", "active": true, "dtype": "string", "transform": null, "alias": null, "_cid": "k_mvyg68l830" }, { "name": "Family", "active": true, "dtype": "string", "transform": null, "alias": null, "_cid": "k_mvyg68l831" } ], "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": "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": "", "delim": ",", "csvUtf8": true, "csvMsq": true, "noConcatenate": false, "useWildcard": false, "_reLine": 104 }, "n42": { "id": "n42", "layer": "qualify", "label": "Qualify_3", "customName": "", "x": 220, "y": 597, "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": "UNQUALIFY", "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": 108 }, "n44": { "id": "n44", "layer": "raw", "label": "tmp_BrandRaw", "customName": "", "x": 322, "y": 822, "srcLibId": null, "srcType": "txt", "path": "$(vPathRaw)Brands.txt", "dest": "", "desc": "", "fields": "*", "where": "", "devComment": "", "opType": "", "transforms": [], "calcFields": [], "columns": [ { "name": "BrandID", "active": true, "dtype": "string", "transform": null, "alias": null, "_cid": "k_mvyg68l832" }, { "name": "BrandName", "active": true, "dtype": "string", "transform": null, "alias": null, "_cid": "k_mvyg68l833" }, { "name": "CountryOfOrigin", "active": true, "dtype": "string", "transform": null, "alias": null, "_cid": "k_mvyg68l834" } ], "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": "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": "", "delim": "|", "csvUtf8": true, "csvMsq": true, "noConcatenate": false, "useWildcard": false, "_reLine": 110 }, "n46": { "id": "n46", "layer": "txf", "label": "tmp_CustomerClean", "customName": "", "x": 656, "y": 548, "srcLibId": null, "srcType": null, "path": "", "dest": "", "desc": "", "fields": "*", "where": "", "devComment": "", "opType": "", "transforms": [ { "fn": "reversed", "group": "reversed", "expr": "Capitalize(Trim(tmp_CustomerRaw.CustomerName))", "alias": "CustomerName", "params": { "newCol": true }, "_tid": "x_mvyg68l719" }, { "fn": "reversed", "group": "reversed", "expr": "ApplyMap('map_DocType', tmp_CustomerRaw.DocType, 'Other')", "alias": "DocTypeName", "params": { "newCol": true }, "_tid": "x_mvyg68l720" }, { "fn": "reversed", "group": "reversed", "expr": "If(Len(Trim(tmp_CustomerRaw.City)) = 0, 'No city', Trim(tmp_CustomerRaw.City))", "alias": "CustomerCity", "params": { "newCol": true }, "_tid": "x_mvyg68l721" }, { "fn": "reversed", "group": "reversed", "expr": "Date(Date#(tmp_CustomerRaw.SignupDate, 'DD/MM/YYYY'))", "alias": "SignupDate", "params": { "newCol": true }, "_tid": "x_mvyg68l722" }, { "fn": "reversed", "group": "reversed", "expr": "ApplyMap('map_CustomerStatus', tmp_CustomerRaw.Status, 'Unknown')", "alias": "CustomerStatus", "params": { "newCol": true }, "_tid": "x_mvyg68l723" }, { "fn": "reversed", "group": "reversed", "expr": "If(tmp_CustomerRaw.CreditLimit >= $(vCreditThreshold), 'High', 'Standard')", "alias": "CreditProfile", "params": { "newCol": true }, "_tid": "x_mvyg68l724" }, { "fn": "reversed", "group": "reversed", "expr": "If(DocNumber = Previous(DocNumber), Peek('SurvivorID'), CustomerID)", "alias": "SurvivorID", "params": { "newCol": true }, "_tid": "x_mvyg68l725" } ], "calcFields": [], "columns": [ { "name": "CustomerID", "active": true, "dtype": "string", "transform": null, "alias": null, "_cid": "k_mvyg68l710", "_srcName": "CustomerID", "_propOriginNodeId": "n36", "_propOriginIdx": "k_mvyg68l51", "keyType": null, "_declared": true, "_fromUpstream": true, "_orphaned": false }, { "name": "tmp_CustomerRaw.CustomerName", "active": false, "dtype": "string", "transform": null, "alias": null, "_cid": "k_mvyg68l711", "_srcName": "CustomerName", "_propOriginNodeId": "n36", "_propOriginIdx": "k_mvyg68l52", "keyType": null, "_fromUpstream": true, "_orphaned": false }, { "name": "tmp_CustomerRaw.DocType", "active": false, "dtype": "string", "transform": null, "alias": null, "_cid": "k_mvyg68l712", "_srcName": "DocType", "_propOriginNodeId": "n36", "_propOriginIdx": "k_mvyg68l53", "keyType": null, "_fromUpstream": true, "_orphaned": false }, { "name": "DocNumber", "active": true, "dtype": "string", "transform": null, "alias": null, "_cid": "k_mvyg68l713", "_srcName": "DocNumber", "_propOriginNodeId": "n36", "_propOriginIdx": "k_mvyg68l54", "keyType": null, "_declared": true, "_fromUpstream": true, "_orphaned": false }, { "name": "tmp_CustomerRaw.City", "active": false, "dtype": "string", "transform": null, "alias": null, "_cid": "k_mvyg68l714", "_srcName": "City", "_propOriginNodeId": "n36", "_propOriginIdx": "k_mvyg68l55", "keyType": null, "_fromUpstream": true, "_orphaned": false }, { "name": "tmp_CustomerRaw.Segment", "active": true, "dtype": "string", "transform": null, "alias": "Segment", "_cid": "k_mvyg68l715", "_srcName": "Segment", "_propOriginNodeId": "n36", "_propOriginIdx": "k_mvyg68l56", "keyType": null, "_declared": true, "_fromUpstream": true, "_orphaned": false }, { "name": "tmp_CustomerRaw.SignupDate", "active": false, "dtype": "string", "transform": null, "alias": null, "_cid": "k_mvyg68l716", "_srcName": "SignupDate", "_propOriginNodeId": "n36", "_propOriginIdx": "k_mvyg68l57", "keyType": null, "_fromUpstream": true, "_orphaned": false }, { "name": "tmp_CustomerRaw.Status", "active": false, "dtype": "string", "transform": null, "alias": null, "_cid": "k_mvyg68l717", "_srcName": "Status", "_propOriginNodeId": "n36", "_propOriginIdx": "k_mvyg68l58", "keyType": null, "_fromUpstream": true, "_orphaned": false }, { "name": "tmp_CustomerRaw.CreditLimit", "active": true, "dtype": "string", "transform": null, "alias": "CreditLimit", "_cid": "k_mvyg68l718", "_srcName": "CreditLimit", "_propOriginNodeId": "n36", "_propOriginIdx": "k_mvyg68l59", "keyType": null, "_declared": true, "_fromUpstream": true, "_orphaned": false } ], "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": "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": "", "noConcatenate": false, "orderByEnabled": true, "orderBy": "DocNumber, CustomerID", "useWildcard": false, "_reLine": 119 }, "n48": { "id": "n48", "layer": "map", "label": "map_CustomerSurvivor", "customName": "", "x": 938, "y": 637, "srcLibId": null, "srcType": null, "path": "", "dest": "", "desc": "", "fields": "*", "where": "", "devComment": "", "opType": "MAPPING", "transforms": [], "calcFields": [], "columns": [], "showColumns": false, "joinSrc": "", "joinFields": "*", "joinType": "LEFT JOIN", "joinMode": "JOIN", "joinResultResident": true, "joinResultName": "", "forceInlineIds": [], "ctAttrField": "", "ctDataField": "", "ctNPrefix": 1, "mapKey": "CustomerID", "mapVal": "SurvivorID", "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": "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": "", "_reMapScriptName": "map_CustomerSurvivor", "_reLine": 135 }, "n50": { "id": "n50", "layer": "txf", "label": "Customer", "customName": "", "x": 938, "y": 911, "srcLibId": null, "srcType": null, "path": "", "dest": "", "desc": "", "fields": "*", "where": "CustomerID = SurvivorID", "devComment": "", "opType": "", "transforms": [], "calcFields": [], "columns": [ { "name": "CustomerID", "active": true, "dtype": "string", "transform": null, "alias": null, "_srcName": "CustomerID", "_propOriginNodeId": "n46", "_propOriginIdx": "k_mvyg68l710", "keyType": null, "_fromUpstream": true, "_declared": true, "_orphaned": false }, { "name": "tmp_CustomerRaw.CustomerName", "active": false, "dtype": "string", "transform": null, "alias": null, "_srcName": "CustomerName", "_propOriginNodeId": "n46", "_propOriginIdx": "k_mvyg68l711", "keyType": null, "_fromUpstream": true, "_orphaned": false }, { "name": "tmp_CustomerRaw.DocType", "active": false, "dtype": "string", "transform": null, "alias": null, "_srcName": "DocType", "_propOriginNodeId": "n46", "_propOriginIdx": "k_mvyg68l712", "keyType": null, "_fromUpstream": true, "_orphaned": true }, { "name": "DocNumber", "active": true, "dtype": "string", "transform": null, "alias": null, "_srcName": "DocNumber", "_propOriginNodeId": "n46", "_propOriginIdx": "k_mvyg68l713", "keyType": null, "_fromUpstream": true, "_declared": true, "_orphaned": false }, { "name": "tmp_CustomerRaw.City", "active": false, "dtype": "string", "transform": null, "alias": null, "_srcName": "City", "_propOriginNodeId": "n46", "_propOriginIdx": "k_mvyg68l714", "keyType": null, "_fromUpstream": true, "_orphaned": true }, { "name": "Segment", "active": true, "dtype": "string", "transform": null, "alias": null, "_srcName": "Segment", "_propOriginNodeId": "n46", "_propOriginIdx": "k_mvyg68l715", "keyType": null, "_fromUpstream": true, "_declared": true, "_orphaned": false }, { "name": "tmp_CustomerRaw.SignupDate", "active": false, "dtype": "string", "transform": null, "alias": null, "_srcName": "SignupDate", "_propOriginNodeId": "n46", "_propOriginIdx": "k_mvyg68l716", "keyType": null, "_fromUpstream": true, "_orphaned": false }, { "name": "tmp_CustomerRaw.Status", "active": false, "dtype": "string", "transform": null, "alias": null, "_srcName": "Status", "_propOriginNodeId": "n46", "_propOriginIdx": "k_mvyg68l717", "keyType": null, "_fromUpstream": true, "_orphaned": true }, { "name": "CreditLimit", "active": true, "dtype": "string", "transform": null, "alias": null, "_srcName": "CreditLimit", "_propOriginNodeId": "n46", "_propOriginIdx": "k_mvyg68l718", "keyType": null, "_fromUpstream": true, "_declared": true, "_orphaned": false }, { "name": "CustomerName", "_srcName": "CustomerName", "active": true, "_fromUpstream": true, "dtype": "string", "_propOriginNodeId": "n46", "_propOriginIdx": "x_mvyg68l719", "alias": null, "keyType": null, "_declared": true, "_orphaned": false }, { "name": "DocTypeName", "_srcName": "DocTypeName", "active": true, "_fromUpstream": true, "dtype": "string", "_propOriginNodeId": "n46", "_propOriginIdx": "x_mvyg68l720", "alias": null, "keyType": null, "_declared": true, "_orphaned": false }, { "name": "CustomerCity", "_srcName": "CustomerCity", "active": true, "_fromUpstream": true, "dtype": "string", "_propOriginNodeId": "n46", "_propOriginIdx": "x_mvyg68l721", "alias": null, "keyType": null, "_declared": true, "_orphaned": false }, { "name": "SignupDate", "_srcName": "SignupDate", "active": true, "_fromUpstream": true, "dtype": "string", "_propOriginNodeId": "n46", "_propOriginIdx": "x_mvyg68l722", "alias": null, "keyType": null, "_declared": true, "_orphaned": false }, { "name": "CustomerStatus", "_srcName": "CustomerStatus", "active": true, "_fromUpstream": true, "dtype": "string", "_propOriginNodeId": "n46", "_propOriginIdx": "x_mvyg68l723", "alias": null, "keyType": null, "_declared": true, "_orphaned": false }, { "name": "CreditProfile", "_srcName": "CreditProfile", "active": true, "_fromUpstream": true, "dtype": "string", "_propOriginNodeId": "n46", "_propOriginIdx": "x_mvyg68l724", "alias": null, "keyType": null, "_declared": true, "_orphaned": false }, { "name": "SurvivorID", "_srcName": "SurvivorID", "active": false, "_fromUpstream": true, "dtype": "string", "_propOriginNodeId": "n46", "_propOriginIdx": "x_mvyg68l725", "alias": null, "keyType": null, "_orphaned": false } ], "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": "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": "", "whereEnabled": true, "noConcatenate": true, "useWildcard": false, "_reLine": 139 }, "n52": { "id": "n52", "layer": "drop", "label": "Drop_3", "customName": "", "x": 1118, "y": 871, "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": [ "n46" ], "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": "", "_reLine": 145 }, "n54": { "id": "n54", "layer": "inline", "label": "Customer_Src", "customName": "", "x": 1220, "y": 911, "srcLibId": null, "srcType": null, "path": "", "dest": "", "desc": "", "fields": "*", "where": "", "devComment": "", "opType": "", "transforms": [], "calcFields": [], "columns": [ { "name": "CustomerID", "active": true, "dtype": "string", "transform": null, "alias": null, "_cid": "k_mvyg68l726" }, { "name": "CustomerName", "active": true, "dtype": "string", "transform": null, "alias": null, "_cid": "k_mvyg68l727" }, { "name": "CustomerStatus", "active": true, "dtype": "string", "transform": null, "alias": null, "_cid": "k_mvyg68l728" } ], "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": [], "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": [ "CustomerID", "CustomerName", "CustomerStatus" ], "inlineRows": [ [ "-1", "Unknown customer", "Unknown" ] ], "synthStage": true }, "n56": { "id": "n56", "layer": "op", "label": "CONCATENATE", "customName": "", "x": 1462, "y": 911, "srcLibId": null, "srcType": null, "path": "", "dest": "", "desc": "", "fields": "*", "where": "", "devComment": "", "opType": "CONCATENATE", "transforms": [], "calcFields": [], "columns": [], "showColumns": false, "joinSrc": "", "joinFields": "*", "joinType": "LEFT JOIN", "joinMode": "JOIN", "joinResultResident": true, "joinResultName": "", "forceInlineIds": [ "n54" ], "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": "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": 148 }, "n59": { "id": "n59", "layer": "txf", "label": "Product", "customName": "", "x": 1220, "y": 815, "srcLibId": null, "srcType": null, "path": "", "dest": "", "desc": "", "fields": "*", "where": "tmp_ProductRaw.Status = 'ACTIVE'", "devComment": "", "opType": "", "transforms": [ { "fn": "reversed", "group": "reversed", "expr": "Capitalize(Trim(tmp_ProductRaw.ProductName))", "alias": "ProductName", "params": { "newCol": true }, "_tid": "x_mvyg68l967" }, { "fn": "reversed", "group": "reversed", "expr": "ApplyMap('map_BrandName', BrandID, 'No brand')", "alias": "BrandName", "params": { "newCol": true }, "_tid": "x_mvyg68l968" }, { "fn": "reversed", "group": "reversed", "expr": "Round((tmp_ProductRaw.ListPrice - tmp_ProductRaw.UnitCost) / tmp_ProductRaw.ListPrice, 0.0001)", "alias": "MarginPct", "params": { "newCol": true }, "_tid": "x_mvyg68l969" } ], "calcFields": [], "columns": [ { "name": "ProductID", "active": true, "dtype": "string", "transform": null, "alias": null, "_cid": "k_mvyg68l954", "_srcName": "ProductID", "_propOriginNodeId": "n38", "_propOriginIdx": "k_mvyg68l835", "keyType": null, "_declared": true, "_fromUpstream": true, "_orphaned": false }, { "name": "tmp_ProductRaw.SKU", "active": true, "dtype": "string", "transform": null, "alias": "SKU", "_cid": "k_mvyg68l955", "_srcName": "SKU", "_propOriginNodeId": "n38", "_propOriginIdx": "k_mvyg68l836", "keyType": null, "_declared": true, "_fromUpstream": true, "_orphaned": false }, { "name": "tmp_ProductRaw.ProductName", "active": false, "dtype": "string", "transform": null, "alias": null, "_cid": "k_mvyg68l956", "_srcName": "ProductName", "_propOriginNodeId": "n38", "_propOriginIdx": "k_mvyg68l837", "keyType": null, "_fromUpstream": true, "_orphaned": false }, { "name": "CategoryID", "active": true, "dtype": "string", "transform": null, "alias": null, "_cid": "k_mvyg68l957", "_srcName": "CategoryID", "_propOriginNodeId": "n38", "_propOriginIdx": "k_mvyg68l838", "keyType": null, "_declared": true, "_fromUpstream": true, "_orphaned": false }, { "name": "BrandID", "active": true, "dtype": "string", "transform": null, "alias": null, "_cid": "k_mvyg68l958", "_srcName": "BrandID", "_propOriginNodeId": "n38", "_propOriginIdx": "k_mvyg68l839", "keyType": null, "_declared": true, "_fromUpstream": true, "_orphaned": false }, { "name": "tmp_ProductRaw.ListPrice", "active": true, "dtype": "string", "transform": null, "alias": "ListPrice", "_cid": "k_mvyg68l959", "_srcName": "ListPrice", "_propOriginNodeId": "n38", "_propOriginIdx": "k_mvyg68l840", "keyType": null, "_declared": true, "_fromUpstream": true, "_orphaned": false }, { "name": "tmp_ProductRaw.UnitCost", "active": true, "dtype": "string", "transform": null, "alias": "UnitCost", "_cid": "k_mvyg68l960", "_srcName": "UnitCost", "_propOriginNodeId": "n38", "_propOriginIdx": "k_mvyg68l841", "keyType": null, "_declared": true, "_fromUpstream": true, "_orphaned": false }, { "name": "tmp_ProductRaw.UnitOfMeasure", "active": true, "dtype": "string", "transform": null, "alias": "UnitOfMeasure", "_cid": "k_mvyg68l961", "_srcName": "UnitOfMeasure", "_propOriginNodeId": "n38", "_propOriginIdx": "k_mvyg68l842", "keyType": null, "_declared": true, "_fromUpstream": true, "_orphaned": false }, { "name": "tmp_ProductRaw.Status", "active": false, "dtype": "string", "transform": null, "alias": null, "_cid": "k_mvyg68l962", "_srcName": "Status", "_propOriginNodeId": "n38", "_propOriginIdx": "k_mvyg68l843", "keyType": null, "_fromUpstream": true, "_orphaned": false }, { "name": "CategoryName", "active": true, "dtype": "string", "transform": null, "alias": null, "_cid": "k_mvyg68l963", "_viaOp": true, "_srcName": "CategoryName", "_propOriginNodeId": "n41", "_propOriginIdx": "k_mvyg68l830", "keyType": null, "_fromUpstream": true, "_orphaned": false }, { "name": "Family", "active": true, "dtype": "string", "transform": null, "alias": null, "_cid": "k_mvyg68l964", "_viaOp": true, "_srcName": "Family", "_propOriginNodeId": "n41", "_propOriginIdx": "k_mvyg68l831", "keyType": null, "_fromUpstream": true, "_orphaned": false }, { "name": "BrandName", "active": false, "dtype": "string", "transform": null, "alias": null, "_cid": "k_mvyg68l965", "_viaOp": true, "_srcName": "BrandName", "_propOriginNodeId": "n44", "_propOriginIdx": "k_mvyg68l833", "keyType": null, "_orphaned": true }, { "name": "CountryOfOrigin", "active": true, "dtype": "string", "transform": null, "alias": null, "_cid": "k_mvyg68l966", "_viaOp": true, "_srcName": "CountryOfOrigin", "_propOriginNodeId": "n44", "_propOriginIdx": "k_mvyg68l834", "keyType": null, "_fromUpstream": true, "_orphaned": false } ], "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": "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": "", "whereEnabled": true, "noConcatenate": false, "useWildcard": false, "_reLine": 158 }, "n61": { "id": "n61", "layer": "op", "label": "LEFT JOIN", "customName": "", "x": 938, "y": 808, "srcLibId": null, "srcType": null, "path": "", "dest": "", "desc": "", "fields": "*", "where": "", "devComment": "", "opType": "LEFT JOIN", "transforms": [], "calcFields": [], "columns": [], "showColumns": false, "joinSrc": "", "joinFields": "*", "joinType": "LEFT JOIN", "joinMode": "JOIN", "joinResultResident": true, "joinResultName": "", "forceInlineIds": [ "n64", "n67" ], "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": "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": 173 }, "n64": { "id": "n64", "layer": "txf", "label": "tmp_CategoryRaw_Filtered", "customName": "tmp_CategoryRaw_Filtered", "x": 322, "y": 637, "srcLibId": null, "srcType": null, "path": "", "dest": "", "desc": "", "fields": "*", "where": "", "devComment": "", "opType": "", "transforms": [], "calcFields": [], "columns": [ { "name": "CategoryID", "active": true, "dtype": "string", "transform": null, "alias": null, "_srcName": "CategoryID", "_propOriginNodeId": "n41", "_propOriginIdx": "k_mvyg68l829", "keyType": null, "_declared": true, "_fromUpstream": true, "_orphaned": false }, { "name": "tmp_CategoryRaw.CategoryName", "active": true, "dtype": "string", "transform": null, "alias": "CategoryName", "_srcName": "CategoryName", "_propOriginNodeId": "n41", "_propOriginIdx": "k_mvyg68l830", "keyType": null, "_declared": true, "_fromUpstream": true, "_orphaned": false }, { "name": "tmp_CategoryRaw.Family", "active": true, "dtype": "string", "transform": null, "alias": "Family", "_srcName": "Family", "_propOriginNodeId": "n41", "_propOriginIdx": "k_mvyg68l831", "keyType": null, "_declared": true, "_fromUpstream": true, "_orphaned": false } ], "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": "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": "", "whereEnabled": false, "groupBy": "", "groupByEnabled": false, "orderBy": "", "orderByEnabled": false, "distinct": true, "useWildcard": false, "copyOf": "n41", "copyWasEmbedded": false }, "n67": { "id": "n67", "layer": "txf", "label": "tmp_BrandRaw_Filtered", "customName": "tmp_BrandRaw_Filtered", "x": 656, "y": 822, "srcLibId": null, "srcType": null, "path": "", "dest": "", "desc": "", "fields": "*", "where": "", "devComment": "", "opType": "", "transforms": [], "calcFields": [], "columns": [ { "name": "BrandID", "active": true, "dtype": "string", "transform": null, "alias": null, "_srcName": "BrandID", "_propOriginNodeId": "n44", "_propOriginIdx": "k_mvyg68l832", "keyType": null, "_declared": true, "_fromUpstream": true, "_orphaned": false }, { "name": "BrandName", "active": false, "dtype": "string", "transform": null, "alias": null, "_srcName": "BrandName", "_propOriginNodeId": "n44", "_propOriginIdx": "k_mvyg68l833", "keyType": null, "_fromUpstream": true, "_orphaned": false }, { "name": "CountryOfOrigin", "active": true, "dtype": "string", "transform": null, "alias": null, "_srcName": "CountryOfOrigin", "_propOriginNodeId": "n44", "_propOriginIdx": "k_mvyg68l834", "keyType": null, "_declared": true, "_fromUpstream": true, "_orphaned": false } ], "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": "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": "", "whereEnabled": false, "groupBy": "", "groupByEnabled": false, "orderBy": "", "orderByEnabled": false, "distinct": false, "useWildcard": false, "copyOf": "n44", "copyWasEmbedded": false }, "n69": { "id": "n69", "layer": "txf", "label": "Salesperson", "customName": "", "x": 656, "y": 377, "srcLibId": null, "srcType": null, "path": "", "dest": "", "desc": "", "fields": "*", "where": "", "devComment": "", "opType": "", "transforms": [ { "fn": "reversed", "group": "reversed", "expr": "Capitalize(Trim(tmp_SalespersonRaw.SalespersonName))", "alias": "SalespersonName", "params": { "newCol": true } }, { "fn": "reversed", "group": "reversed", "expr": "Date(Date#(tmp_SalespersonRaw.HireDate, 'YYYY-MM-DD'))", "alias": "HireDate", "params": { "newCol": true } } ], "calcFields": [], "columns": [ { "name": "SalespersonID", "active": true, "dtype": "string", "transform": null, "alias": null, "_srcName": "SalespersonID", "_propOriginNodeId": "n39", "_propOriginIdx": "k_mvyg68l844", "keyType": null, "_declared": true, "_fromUpstream": true, "_orphaned": false }, { "name": "tmp_SalespersonRaw.SalespersonName", "active": false, "dtype": "string", "transform": null, "alias": null, "_srcName": "SalespersonName", "_propOriginNodeId": "n39", "_propOriginIdx": "k_mvyg68l845", "keyType": null, "_fromUpstream": true, "_orphaned": false }, { "name": "BranchID", "active": true, "dtype": "string", "transform": null, "alias": "HomeBranchID", "_srcName": "BranchID", "_propOriginNodeId": "n39", "_propOriginIdx": "k_mvyg68l846", "keyType": null, "_declared": true, "_fromUpstream": true, "_orphaned": false }, { "name": "tmp_SalespersonRaw.HireDate", "active": false, "dtype": "string", "transform": null, "alias": null, "_srcName": "HireDate", "_propOriginNodeId": "n39", "_propOriginIdx": "k_mvyg68l847", "keyType": null, "_fromUpstream": true, "_orphaned": false }, { "name": "tmp_SalespersonRaw.MonthlyTarget", "active": true, "dtype": "string", "transform": null, "alias": "MonthlyTarget", "_srcName": "MonthlyTarget", "_propOriginNodeId": "n39", "_propOriginIdx": "k_mvyg68l848", "keyType": null, "_declared": true, "_fromUpstream": true, "_orphaned": false } ], "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": "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": "", "noConcatenate": false, "useWildcard": false, "_reLine": 182 }, "n71": { "id": "n71", "layer": "op", "label": "LEFT JOIN_2", "customName": "", "x": 322, "y": 279, "srcLibId": null, "srcType": null, "path": "", "dest": "", "desc": "", "fields": "*", "where": "", "devComment": "", "opType": "LEFT JOIN", "transforms": [], "calcFields": [], "columns": [], "showColumns": false, "joinSrc": "", "joinFields": "*", "joinType": "LEFT JOIN", "joinMode": "KEEP", "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": "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": "", "keepRefId": "n3" }, "n74": { "id": "n74", "layer": "txf", "label": "Branch", "customName": "", "x": 322, "y": 459, "srcLibId": null, "srcType": null, "path": "", "dest": "", "desc": "", "fields": "*", "where": "", "devComment": "", "opType": "", "transforms": [], "calcFields": [], "columns": [ { "name": "BranchID", "active": true, "dtype": "string", "transform": null, "alias": null, "_srcName": "BranchID", "_propOriginNodeId": "n40", "_propOriginIdx": "k_mvyg68l849", "keyType": null, "_declared": true, "_fromUpstream": true, "_orphaned": false }, { "name": "tmp_BranchRaw.BranchName", "active": true, "dtype": "string", "transform": null, "alias": "BranchName", "_srcName": "BranchName", "_propOriginNodeId": "n40", "_propOriginIdx": "k_mvyg68l850", "keyType": null, "_declared": true, "_fromUpstream": true, "_orphaned": false }, { "name": "tmp_BranchRaw.Region", "active": true, "dtype": "string", "transform": null, "alias": "Region", "_srcName": "Region", "_propOriginNodeId": "n40", "_propOriginIdx": "k_mvyg68l851", "keyType": null, "_declared": true, "_fromUpstream": true, "_orphaned": false }, { "name": "tmp_BranchRaw.City", "active": true, "dtype": "string", "transform": null, "alias": "BranchCity", "_srcName": "City", "_propOriginNodeId": "n40", "_propOriginIdx": "k_mvyg68l852", "keyType": null, "_declared": true, "_fromUpstream": true, "_orphaned": false }, { "name": "tmp_BranchRaw.Format", "active": true, "dtype": "string", "transform": null, "alias": "BranchFormat", "_srcName": "Format", "_propOriginNodeId": "n40", "_propOriginIdx": "k_mvyg68l853", "keyType": null, "_declared": true, "_fromUpstream": true, "_orphaned": false } ], "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": "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": "", "noConcatenate": false, "useWildcard": false, "_reLine": 192 }, "n76": { "id": "n76", "layer": "drop", "label": "Drop_4", "customName": "", "x": 502, "y": 419, "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": [ "n36", "n38", "n39", "n40", "n41", "n44" ], "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": "", "_reLine": 201 }, "n78": { "id": "n78", "layer": "txf", "label": "tmp_Sales", "customName": "", "x": 1986, "y": 541, "srcLibId": null, "srcType": null, "path": "", "dest": "", "desc": "", "fields": "*", "where": "Quantity > 0", "devComment": "", "opType": "", "transforms": [ { "fn": "reversed", "group": "reversed", "expr": "Date(Date#(SaleDate, 'YYYY-MM-DD'))", "alias": "SaleDate", "params": { "newCol": true }, "_tid": "x_mvyg68ld130" }, { "fn": "reversed", "group": "reversed", "expr": "ApplyMap('map_CustomerSurvivor', CustomerID, -1)", "alias": "CustomerID", "params": { "newCol": true }, "_tid": "x_mvyg68ld131" }, { "fn": "reversed", "group": "reversed", "expr": "ApplyMap('map_ChannelName', Channel, 'Other')", "alias": "ChannelName", "params": { "newCol": true }, "_tid": "x_mvyg68ld132" }, { "fn": "reversed", "group": "reversed", "expr": "Quantity * UnitPrice * (1 - DiscountPct / 100)", "alias": "NetAmount", "params": { "newCol": true }, "_tid": "x_mvyg68ld133" } ], "calcFields": [], "columns": [ { "name": "Dummy", "active": false, "dtype": "string", "transform": null, "alias": null, "_cid": "k_mvyg68ld99", "_srcName": "Dummy", "_propOriginNodeId": "n3", "_propOriginIdx": "k_mvyg68lb79", "keyType": null, "_fromUpstream": true, "_orphaned": false }, { "name": "SaleID", "active": true, "dtype": "string", "transform": null, "alias": null, "_propOriginNodeId": "n3", "_loopSync": true, "_propOriginIdx": "k_mvyg68m4146", "_cid": "k_mvyg68ld100", "_srcName": "SaleID", "keyType": null, "_declared": true, "_fromUpstream": true, "_orphaned": false }, { "name": "SaleDate", "active": false, "dtype": "string", "transform": null, "alias": null, "_propOriginNodeId": "n3", "_loopSync": true, "_propOriginIdx": "k_mvyg68m5147", "_cid": "k_mvyg68ld101", "_srcName": "SaleDate", "keyType": null, "_fromUpstream": true, "_orphaned": false }, { "name": "CustomerID", "active": false, "dtype": "string", "transform": null, "alias": null, "_propOriginNodeId": "n3", "_loopSync": true, "_propOriginIdx": "k_mvyg68m5148", "_cid": "k_mvyg68ld102", "_srcName": "CustomerID", "keyType": null, "_fromUpstream": true, "_orphaned": false }, { "name": "ProductID", "active": true, "dtype": "string", "transform": null, "alias": null, "_propOriginNodeId": "n3", "_loopSync": true, "_propOriginIdx": "k_mvyg68m5149", "_cid": "k_mvyg68ld103", "_srcName": "ProductID", "keyType": null, "_declared": true, "_fromUpstream": true, "_orphaned": false }, { "name": "SalespersonID", "active": true, "dtype": "string", "transform": null, "alias": null, "_propOriginNodeId": "n3", "_loopSync": true, "_propOriginIdx": "k_mvyg68m5150", "_cid": "k_mvyg68ld104", "_srcName": "SalespersonID", "keyType": null, "_declared": true, "_fromUpstream": true, "_orphaned": false }, { "name": "BranchID", "active": true, "dtype": "string", "transform": null, "alias": null, "_propOriginNodeId": "n3", "_loopSync": true, "_propOriginIdx": "k_mvyg68m5151", "_cid": "k_mvyg68ld105", "_srcName": "BranchID", "keyType": null, "_declared": true, "_fromUpstream": true, "_orphaned": false }, { "name": "Quantity", "active": true, "dtype": "string", "transform": null, "alias": null, "_propOriginNodeId": "n3", "_loopSync": true, "_propOriginIdx": "k_mvyg68m5152", "_cid": "k_mvyg68ld106", "_srcName": "Quantity", "keyType": null, "_declared": true, "_fromUpstream": true, "_orphaned": false }, { "name": "UnitPrice", "active": true, "dtype": "string", "transform": null, "alias": null, "_propOriginNodeId": "n3", "_loopSync": true, "_propOriginIdx": "k_mvyg68m5153", "_cid": "k_mvyg68ld107", "_srcName": "UnitPrice", "keyType": null, "_declared": true, "_fromUpstream": true, "_orphaned": false }, { "name": "DiscountPct", "active": true, "dtype": "string", "transform": null, "alias": null, "_propOriginNodeId": "n3", "_loopSync": true, "_propOriginIdx": "k_mvyg68m5154", "_cid": "k_mvyg68ld108", "_srcName": "DiscountPct", "keyType": null, "_declared": true, "_fromUpstream": true, "_orphaned": false }, { "name": "Currency", "active": true, "dtype": "string", "transform": null, "alias": null, "_propOriginNodeId": "n3", "_loopSync": true, "_propOriginIdx": "k_mvyg68m5155", "_cid": "k_mvyg68ld109", "_srcName": "Currency", "keyType": null, "_declared": true, "_fromUpstream": true, "_orphaned": false }, { "name": "Channel", "active": false, "dtype": "string", "transform": null, "alias": null, "_propOriginNodeId": "n3", "_loopSync": true, "_propOriginIdx": "k_mvyg68m5156", "_cid": "k_mvyg68ld110", "_srcName": "Channel", "keyType": null, "_fromUpstream": true, "_orphaned": false }, { "name": "SourceFile", "active": true, "dtype": "string", "alias": null, "_propOriginNodeId": "n3", "_loopSync": true, "_propOriginIdx": "k_mvyg68m5157", "_cid": "k_mvyg68ld111", "_srcName": "SourceFile", "keyType": null, "_declared": true, "_fromUpstream": true, "_orphaned": false }, { "name": "tmp_ProductRaw.SKU", "active": false, "dtype": "string", "transform": null, "alias": null, "_cid": "k_mvyg68ld112", "_viaOp": true, "_srcName": "SKU", "_propOriginNodeId": "n59", "_propOriginIdx": "k_mvyg68l955", "keyType": null, "_fromUpstream": true, "_orphaned": true }, { "name": "tmp_ProductRaw.ProductName", "active": false, "dtype": "string", "transform": null, "alias": null, "_cid": "k_mvyg68ld113", "_viaOp": true, "_srcName": "ProductName", "_propOriginNodeId": "n59", "_propOriginIdx": "k_mvyg68l956", "keyType": null, "_fromUpstream": true, "_orphaned": true }, { "name": "CategoryID", "active": false, "dtype": "string", "transform": null, "alias": null, "_cid": "k_mvyg68ld114", "_viaOp": true, "_srcName": "CategoryID", "_propOriginNodeId": "n59", "_propOriginIdx": "k_mvyg68l957", "keyType": null, "_fromUpstream": true, "_orphaned": true }, { "name": "BrandID", "active": false, "dtype": "string", "transform": null, "alias": null, "_cid": "k_mvyg68ld115", "_viaOp": true, "_srcName": "BrandID", "_propOriginNodeId": "n59", "_propOriginIdx": "k_mvyg68l958", "keyType": null, "_fromUpstream": true, "_orphaned": true }, { "name": "tmp_ProductRaw.ListPrice", "active": false, "dtype": "string", "transform": null, "alias": null, "_cid": "k_mvyg68ld116", "_viaOp": true, "_srcName": "ListPrice", "_propOriginNodeId": "n59", "_propOriginIdx": "k_mvyg68l959", "keyType": null, "_fromUpstream": true, "_orphaned": true }, { "name": "tmp_ProductRaw.UnitCost", "active": false, "dtype": "string", "transform": null, "alias": null, "_cid": "k_mvyg68ld117", "_viaOp": true, "_srcName": "UnitCost", "_propOriginNodeId": "n59", "_propOriginIdx": "k_mvyg68l960", "keyType": null, "_fromUpstream": true, "_orphaned": true }, { "name": "tmp_ProductRaw.UnitOfMeasure", "active": false, "dtype": "string", "transform": null, "alias": null, "_cid": "k_mvyg68ld118", "_viaOp": true, "_srcName": "UnitOfMeasure", "_propOriginNodeId": "n59", "_propOriginIdx": "k_mvyg68l961", "keyType": null, "_fromUpstream": true, "_orphaned": true }, { "name": "tmp_ProductRaw.Status", "active": false, "dtype": "string", "transform": null, "alias": null, "_cid": "k_mvyg68ld119", "_viaOp": true, "_srcName": "Status", "_propOriginNodeId": "n59", "_propOriginIdx": "k_mvyg68l962", "keyType": null, "_fromUpstream": true, "_orphaned": true }, { "name": "tmp_CategoryRaw.CategoryName", "active": false, "dtype": "string", "transform": null, "alias": null, "_cid": "k_mvyg68ld120", "_viaOp": true, "_srcName": "CategoryName", "_propOriginNodeId": "n59", "_propOriginIdx": "k_mvyg68l963", "keyType": null, "_fromUpstream": true, "_orphaned": true }, { "name": "tmp_CategoryRaw.Family", "active": false, "dtype": "string", "transform": null, "alias": null, "_cid": "k_mvyg68ld121", "_viaOp": true, "_srcName": "Family", "_propOriginNodeId": "n59", "_propOriginIdx": "k_mvyg68l964", "keyType": null, "_fromUpstream": true, "_orphaned": true }, { "name": "BrandName", "active": false, "dtype": "string", "transform": null, "alias": null, "_cid": "k_mvyg68ld122", "_viaOp": true, "_srcName": "BrandName", "_propOriginNodeId": "n59", "_propOriginIdx": "k_mvyg68l965", "keyType": null, "_fromUpstream": true, "_orphaned": true }, { "name": "CountryOfOrigin", "active": false, "dtype": "string", "transform": null, "alias": null, "_cid": "k_mvyg68ld123", "_viaOp": true, "_srcName": "CountryOfOrigin", "_propOriginNodeId": "n59", "_propOriginIdx": "k_mvyg68l966", "keyType": null, "_fromUpstream": true, "_orphaned": true }, { "name": "ProductName", "_srcName": "ProductName", "active": false, "_fromUpstream": true, "dtype": "string", "_propOriginNodeId": "n59", "_propOriginIdx": "x_mvyg68l967", "alias": null, "keyType": null, "_cid": "k_mvyg68ld124", "_viaOp": true, "_orphaned": true }, { "name": "MarginPct", "_srcName": "MarginPct", "active": false, "_fromUpstream": true, "dtype": "string", "_propOriginNodeId": "n59", "_propOriginIdx": "x_mvyg68l969", "alias": null, "keyType": null, "_cid": "k_mvyg68ld126", "_viaOp": true, "_orphaned": true }, { "name": "ValidFromDate", "_srcName": "ValidFromDate", "active": false, "dtype": "string", "_propOriginNodeId": "n90", "alias": null, "keyType": null, "_cid": "k_mvyg68ld127", "_viaOp": true, "_fromUpstream": true, "_propOriginIdx": "k_mvyg68lb75", "_orphaned": true }, { "name": "ValidToDate", "_srcName": "ValidToDate", "active": false, "dtype": "string", "_propOriginNodeId": "n90", "alias": null, "keyType": null, "_cid": "k_mvyg68ld128", "_viaOp": true, "_fromUpstream": true, "_propOriginIdx": "k_mvyg68lb76", "_orphaned": true }, { "name": "Rate", "active": true, "dtype": "string", "transform": null, "alias": null, "_cid": "k_mvyg68ld129", "_viaOp": true, "_srcName": "Rate", "_propOriginNodeId": "n90", "_propOriginIdx": "k_mvyg68lb78", "keyType": null, "_fromUpstream": true, "_orphaned": false } ], "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": "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": "", "whereEnabled": true, "noConcatenate": false, "useWildcard": false, "_reLine": 208 }, "n80": { "id": "n80", "layer": "drop", "label": "Drop_5", "customName": "", "x": 2166, "y": 508, "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": [ "n3" ], "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": "", "_reLine": 226 }, "n82": { "id": "n82", "layer": "op", "label": "INNER JOIN", "customName": "", "x": 1744, "y": 815, "srcLibId": null, "srcType": null, "path": "", "dest": "", "desc": "", "fields": "*", "where": "", "devComment": "", "opType": "INNER JOIN", "transforms": [], "calcFields": [], "columns": [], "showColumns": false, "joinSrc": "", "joinFields": "*", "joinType": "INNER JOIN", "joinMode": "JOIN", "joinResultResident": true, "joinResultName": "", "forceInlineIds": [ "n85" ], "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": "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": 228 }, "n85": { "id": "n85", "layer": "txf", "label": "Product_Filtered", "customName": "Product_Filtered", "x": 1462, "y": 815, "srcLibId": null, "srcType": null, "path": "", "dest": "", "desc": "", "fields": "*", "where": "", "devComment": "", "opType": "", "transforms": [], "calcFields": [], "columns": [ { "name": "ProductID", "active": true, "dtype": "string", "transform": null, "alias": null, "_srcName": "ProductID", "_propOriginNodeId": "n59", "_propOriginIdx": "k_mvyg68l954", "keyType": null, "_fromUpstream": true, "_declared": true, "_orphaned": false }, { "name": "SKU", "active": false, "dtype": "string", "transform": null, "alias": null, "_srcName": "SKU", "_propOriginNodeId": "n59", "_propOriginIdx": "k_mvyg68l955", "keyType": null, "_fromUpstream": true, "_orphaned": false }, { "name": "tmp_ProductRaw.ProductName", "active": false, "dtype": "string", "transform": null, "alias": null, "_srcName": "ProductName", "_propOriginNodeId": "n59", "_propOriginIdx": "k_mvyg68l956", "keyType": null, "_fromUpstream": true, "_orphaned": false }, { "name": "CategoryID", "active": false, "dtype": "string", "transform": null, "alias": null, "_srcName": "CategoryID", "_propOriginNodeId": "n59", "_propOriginIdx": "k_mvyg68l957", "keyType": null, "_fromUpstream": true, "_orphaned": false }, { "name": "BrandID", "active": false, "dtype": "string", "transform": null, "alias": null, "_srcName": "BrandID", "_propOriginNodeId": "n59", "_propOriginIdx": "k_mvyg68l958", "keyType": null, "_fromUpstream": true, "_orphaned": false }, { "name": "ListPrice", "active": false, "dtype": "string", "transform": null, "alias": null, "_srcName": "ListPrice", "_propOriginNodeId": "n59", "_propOriginIdx": "k_mvyg68l959", "keyType": null, "_fromUpstream": true, "_orphaned": false }, { "name": "UnitCost", "active": false, "dtype": "string", "transform": null, "alias": null, "_srcName": "UnitCost", "_propOriginNodeId": "n59", "_propOriginIdx": "k_mvyg68l960", "keyType": null, "_fromUpstream": true, "_orphaned": false }, { "name": "UnitOfMeasure", "active": false, "dtype": "string", "transform": null, "alias": null, "_srcName": "UnitOfMeasure", "_propOriginNodeId": "n59", "_propOriginIdx": "k_mvyg68l961", "keyType": null, "_fromUpstream": true, "_orphaned": false }, { "name": "tmp_ProductRaw.Status", "active": false, "dtype": "string", "transform": null, "alias": null, "_srcName": "Status", "_propOriginNodeId": "n59", "_propOriginIdx": "k_mvyg68l962", "keyType": null, "_fromUpstream": true, "_orphaned": true }, { "name": "CategoryName", "active": false, "dtype": "string", "transform": null, "alias": null, "_srcName": "CategoryName", "_propOriginNodeId": "n59", "_propOriginIdx": "k_mvyg68l963", "keyType": null, "_fromUpstream": true, "_orphaned": false }, { "name": "Family", "active": false, "dtype": "string", "transform": null, "alias": null, "_srcName": "Family", "_propOriginNodeId": "n59", "_propOriginIdx": "k_mvyg68l964", "keyType": null, "_fromUpstream": true, "_orphaned": false }, { "name": "BrandName", "active": false, "dtype": "string", "transform": null, "alias": null, "_srcName": "BrandName", "_propOriginNodeId": "n59", "_propOriginIdx": "x_mvyg68l968", "keyType": null, "_fromUpstream": true, "_orphaned": false }, { "name": "CountryOfOrigin", "active": false, "dtype": "string", "transform": null, "alias": null, "_srcName": "CountryOfOrigin", "_propOriginNodeId": "n59", "_propOriginIdx": "k_mvyg68l966", "keyType": null, "_fromUpstream": true, "_orphaned": false }, { "name": "ProductName", "_srcName": "ProductName", "active": false, "_fromUpstream": true, "dtype": "string", "_propOriginNodeId": "n59", "_propOriginIdx": "x_mvyg68l967", "alias": null, "keyType": null, "_orphaned": false }, { "name": "MarginPct", "_srcName": "MarginPct", "active": false, "_fromUpstream": true, "dtype": "string", "_propOriginNodeId": "n59", "_propOriginIdx": "x_mvyg68l969", "alias": null, "keyType": null, "_orphaned": false } ], "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": "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": "", "whereEnabled": false, "groupBy": "", "groupByEnabled": false, "orderBy": "", "orderByEnabled": false, "distinct": false, "useWildcard": false, "copyOf": "n59", "copyWasEmbedded": false }, "n87": { "id": "n87", "layer": "raw", "label": "tmp_ExchangeRate", "customName": "", "x": 40, "y": 726, "srcLibId": null, "srcType": "txt", "path": "$(vPathRaw)ExchangeRates.csv", "dest": "", "desc": "", "fields": "*", "where": "", "devComment": "", "opType": "", "transforms": [ { "fn": "reversed", "group": "reversed", "expr": "Date#(ValidFromDate, 'YYYY-MM-DD')", "alias": "ValidFromDate", "params": { "newCol": true }, "_tid": "x_mvyg68l972" }, { "fn": "reversed", "group": "reversed", "expr": "Date#(ValidToDate, 'YYYY-MM-DD')", "alias": "ValidToDate", "params": { "newCol": true }, "_tid": "x_mvyg68l973" } ], "calcFields": [], "columns": [ { "name": "Currency", "active": true, "dtype": "string", "transform": null, "alias": null, "_cid": "k_mvyg68l970" }, { "name": "Rate", "active": true, "dtype": "string", "transform": null, "alias": null, "_cid": "k_mvyg68l971" } ], "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": "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": "", "delim": ",", "csvUtf8": true, "csvMsq": true, "noConcatenate": false, "useWildcard": false, "_reLine": 236 }, "n88": { "id": "n88", "layer": "intervalmatch", "label": "tmp_RateBridge", "customName": "", "x": 220, "y": 686, "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": "SaleDate", "imStartCol": "ValidFromDate", "imEndCol": "ValidToDate", "imExtraKeys": "Currency", "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": 244 }, "n90": { "id": "n90", "layer": "txf", "label": "tmp_SaleRate", "customName": "", "x": 938, "y": 726, "srcLibId": null, "srcType": null, "path": "", "dest": "", "desc": "", "fields": "*", "where": "", "devComment": "", "opType": "", "transforms": [], "calcFields": [], "columns": [ { "name": "SaleDate", "_srcName": "SaleDate", "active": true, "dtype": "string", "_propOriginNodeId": "n88", "alias": null, "keyType": null, "_cid": "k_mvyg68lb74", "_declared": true, "_orphaned": false }, { "name": "ValidFromDate", "_srcName": "ValidFromDate", "active": true, "dtype": "string", "_propOriginNodeId": "n88", "alias": null, "keyType": null, "_cid": "k_mvyg68lb75", "_declared": true, "_orphaned": false }, { "name": "ValidToDate", "_srcName": "ValidToDate", "active": true, "dtype": "string", "_propOriginNodeId": "n88", "alias": null, "keyType": null, "_cid": "k_mvyg68lb76", "_declared": true, "_orphaned": false }, { "name": "Currency", "_srcName": "Currency", "active": true, "dtype": "string", "_propOriginNodeId": "n88", "alias": null, "keyType": null, "_cid": "k_mvyg68lb77", "_declared": true, "_orphaned": false }, { "name": "Rate", "active": true, "dtype": "string", "transform": null, "alias": null, "_cid": "k_mvyg68lb78", "_viaOp": true, "_srcName": "Rate", "_propOriginNodeId": "n87", "_propOriginIdx": "k_mvyg68l971", "keyType": null, "_fromUpstream": true, "_orphaned": false } ], "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": "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": "", "noConcatenate": true, "useWildcard": false, "_reLine": 249 }, "n92": { "id": "n92", "layer": "op", "label": "LEFT JOIN_3", "customName": "", "x": 656, "y": 719, "srcLibId": null, "srcType": null, "path": "", "dest": "", "desc": "", "fields": "*", "where": "", "devComment": "", "opType": "LEFT JOIN", "transforms": [], "calcFields": [], "columns": [], "showColumns": false, "joinSrc": "", "joinFields": "*", "joinType": "LEFT JOIN", "joinMode": "JOIN", "joinResultResident": true, "joinResultName": "", "forceInlineIds": [ "n95" ], "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": "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": 254 }, "n95": { "id": "n95", "layer": "txf", "label": "tmp_ExchangeRate_Filtered", "customName": "tmp_ExchangeRate_Filtered", "x": 322, "y": 726, "srcLibId": null, "srcType": null, "path": "", "dest": "", "desc": "", "fields": "*", "where": "", "devComment": "", "opType": "", "transforms": [], "calcFields": [], "columns": [ { "name": "Currency", "active": true, "dtype": "string", "transform": null, "alias": null, "_srcName": "Currency", "_propOriginNodeId": "n87", "_propOriginIdx": "k_mvyg68l970", "keyType": null, "_declared": true, "_fromUpstream": true, "_orphaned": false }, { "name": "Rate", "active": true, "dtype": "string", "transform": null, "alias": null, "_srcName": "Rate", "_propOriginNodeId": "n87", "_propOriginIdx": "k_mvyg68l971", "keyType": null, "_declared": true, "_fromUpstream": true, "_orphaned": false }, { "name": "ValidFromDate", "_srcName": "ValidFromDate", "active": true, "dtype": "string", "_propOriginNodeId": "n87", "_propOriginIdx": "x_mvyg68l972", "alias": null, "keyType": null, "_declared": true, "_fromUpstream": true, "_orphaned": false }, { "name": "ValidToDate", "_srcName": "ValidToDate", "active": true, "dtype": "string", "_propOriginNodeId": "n87", "_propOriginIdx": "x_mvyg68l973", "alias": null, "keyType": null, "_declared": true, "_fromUpstream": true, "_orphaned": false } ], "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": "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": "", "whereEnabled": false, "groupBy": "", "groupByEnabled": false, "orderBy": "", "orderByEnabled": false, "distinct": false, "useWildcard": false, "copyOf": "n87", "copyWasEmbedded": false }, "n98": { "id": "n98", "layer": "op", "label": "LEFT JOIN_4", "customName": "", "x": 1462, "y": 719, "srcLibId": null, "srcType": null, "path": "", "dest": "", "desc": "", "fields": "*", "where": "", "devComment": "", "opType": "LEFT JOIN", "transforms": [], "calcFields": [], "columns": [], "showColumns": false, "joinSrc": "", "joinFields": "*", "joinType": "LEFT JOIN", "joinMode": "JOIN", "joinResultResident": true, "joinResultName": "", "forceInlineIds": [ "n101" ], "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": "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": 258 }, "n101": { "id": "n101", "layer": "txf", "label": "tmp_SaleRate_Filtered", "customName": "tmp_SaleRate_Filtered", "x": 1220, "y": 719, "srcLibId": null, "srcType": null, "path": "", "dest": "", "desc": "", "fields": "*", "where": "Currency <> '$(vBaseCurrency)'", "devComment": "", "opType": "", "transforms": [], "calcFields": [], "columns": [ { "name": "SaleDate", "_srcName": "SaleDate", "active": true, "dtype": "string", "_propOriginNodeId": "n90", "alias": null, "keyType": null, "_fromUpstream": true, "_propOriginIdx": "k_mvyg68lb74", "_declared": true, "_orphaned": false }, { "name": "ValidFromDate", "_srcName": "ValidFromDate", "active": false, "dtype": "string", "_propOriginNodeId": "n90", "alias": null, "keyType": null, "_fromUpstream": true, "_propOriginIdx": "k_mvyg68lb75", "_orphaned": false }, { "name": "ValidToDate", "_srcName": "ValidToDate", "active": false, "dtype": "string", "_propOriginNodeId": "n90", "alias": null, "keyType": null, "_fromUpstream": true, "_propOriginIdx": "k_mvyg68lb76", "_orphaned": false }, { "name": "Currency", "_srcName": "Currency", "active": true, "dtype": "string", "_propOriginNodeId": "n90", "alias": null, "keyType": null, "_fromUpstream": true, "_propOriginIdx": "k_mvyg68lb77", "_declared": true, "_orphaned": false }, { "name": "Rate", "active": true, "dtype": "string", "transform": null, "alias": null, "_srcName": "Rate", "_propOriginNodeId": "n90", "_propOriginIdx": "k_mvyg68lb78", "keyType": null, "_fromUpstream": true, "_declared": true, "_orphaned": false } ], "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": "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": "", "whereEnabled": true, "groupBy": "", "groupByEnabled": false, "orderBy": "", "orderByEnabled": false, "distinct": false, "useWildcard": false, "copyOf": "n90", "copyWasEmbedded": false }, "n103": { "id": "n103", "layer": "drop", "label": "Drop_6", "customName": "", "x": 1642, "y": 686, "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": [ "n88", "n90", "n87" ], "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": "", "_reLine": 263 }, "n105": { "id": "n105", "layer": "txf", "label": "Sales", "customName": "", "x": 2268, "y": 548, "srcLibId": null, "srcType": null, "path": "", "dest": "", "desc": "", "fields": "*", "where": "", "devComment": "", "opType": "", "transforms": [ { "fn": "reversed", "group": "reversed", "expr": "Round(NetAmount * Alt(Rate, 1))", "alias": "NetAmountCOP", "params": { "newCol": true } } ], "calcFields": [], "columns": [ { "name": "Dummy", "active": false, "dtype": "string", "transform": null, "alias": null, "_srcName": "Dummy", "_propOriginNodeId": "n78", "_propOriginIdx": "k_mvyg68ld99", "keyType": null, "_fromUpstream": true, "_orphaned": true }, { "name": "SaleID", "active": true, "dtype": "string", "transform": null, "alias": null, "_propOriginNodeId": "n78", "_loopSync": true, "_propOriginIdx": "k_mvyg68ld100", "_srcName": "SaleID", "keyType": null, "_fromUpstream": true, "_orphaned": false }, { "name": "SaleDate", "active": true, "dtype": "string", "transform": null, "alias": null, "_propOriginNodeId": "n78", "_loopSync": true, "_propOriginIdx": "x_mvyg68ld130", "_srcName": "SaleDate", "keyType": null, "_fromUpstream": true, "_orphaned": false }, { "name": "CustomerID", "active": true, "dtype": "string", "transform": null, "alias": null, "_propOriginNodeId": "n78", "_loopSync": true, "_propOriginIdx": "x_mvyg68ld131", "_srcName": "CustomerID", "keyType": null, "_fromUpstream": true, "_orphaned": false }, { "name": "ProductID", "active": true, "dtype": "string", "transform": null, "alias": null, "_propOriginNodeId": "n78", "_loopSync": true, "_propOriginIdx": "k_mvyg68ld103", "_srcName": "ProductID", "keyType": null, "_fromUpstream": true, "_orphaned": false }, { "name": "SalespersonID", "active": true, "dtype": "string", "transform": null, "alias": null, "_propOriginNodeId": "n78", "_loopSync": true, "_propOriginIdx": "k_mvyg68ld104", "_srcName": "SalespersonID", "keyType": null, "_fromUpstream": true, "_orphaned": false }, { "name": "BranchID", "active": true, "dtype": "string", "transform": null, "alias": null, "_propOriginNodeId": "n78", "_loopSync": true, "_propOriginIdx": "k_mvyg68ld105", "_srcName": "BranchID", "keyType": null, "_fromUpstream": true, "_orphaned": false }, { "name": "Quantity", "active": true, "dtype": "string", "transform": null, "alias": null, "_propOriginNodeId": "n78", "_loopSync": true, "_propOriginIdx": "k_mvyg68ld106", "_srcName": "Quantity", "keyType": null, "_fromUpstream": true, "_orphaned": false }, { "name": "UnitPrice", "active": true, "dtype": "string", "transform": null, "alias": null, "_propOriginNodeId": "n78", "_loopSync": true, "_propOriginIdx": "k_mvyg68ld107", "_srcName": "UnitPrice", "keyType": null, "_fromUpstream": true, "_orphaned": false }, { "name": "DiscountPct", "active": true, "dtype": "string", "transform": null, "alias": null, "_propOriginNodeId": "n78", "_loopSync": true, "_propOriginIdx": "k_mvyg68ld108", "_srcName": "DiscountPct", "keyType": null, "_fromUpstream": true, "_orphaned": false }, { "name": "Currency", "active": true, "dtype": "string", "transform": null, "alias": null, "_propOriginNodeId": "n78", "_loopSync": true, "_propOriginIdx": "k_mvyg68ld109", "_srcName": "Currency", "keyType": null, "_fromUpstream": true, "_orphaned": false }, { "name": "Channel", "active": false, "dtype": "string", "transform": null, "alias": null, "_propOriginNodeId": "n78", "_loopSync": true, "_propOriginIdx": "k_mvyg68ld110", "_srcName": "Channel", "keyType": null, "_fromUpstream": true, "_orphaned": true }, { "name": "SourceFile", "active": true, "dtype": "string", "alias": null, "_propOriginNodeId": "n78", "_loopSync": true, "_propOriginIdx": "k_mvyg68ld111", "_srcName": "SourceFile", "keyType": null, "_fromUpstream": true, "_orphaned": false }, { "name": "tmp_ProductRaw.SKU", "active": false, "dtype": "string", "transform": null, "alias": null, "_srcName": "SKU", "_propOriginNodeId": "n78", "_propOriginIdx": "k_mvyg68ld112", "keyType": null, "_fromUpstream": true, "_orphaned": true }, { "name": "tmp_ProductRaw.ProductName", "active": false, "dtype": "string", "transform": null, "alias": null, "_srcName": "ProductName", "_propOriginNodeId": "n78", "_propOriginIdx": "k_mvyg68ld113", "keyType": null, "_fromUpstream": true, "_orphaned": true }, { "name": "CategoryID", "active": false, "dtype": "string", "transform": null, "alias": null, "_srcName": "CategoryID", "_propOriginNodeId": "n78", "_propOriginIdx": "k_mvyg68ld114", "keyType": null, "_fromUpstream": true, "_orphaned": true }, { "name": "BrandID", "active": false, "dtype": "string", "transform": null, "alias": null, "_srcName": "BrandID", "_propOriginNodeId": "n78", "_propOriginIdx": "k_mvyg68ld115", "keyType": null, "_fromUpstream": true, "_orphaned": true }, { "name": "tmp_ProductRaw.ListPrice", "active": false, "dtype": "string", "transform": null, "alias": null, "_srcName": "ListPrice", "_propOriginNodeId": "n78", "_propOriginIdx": "k_mvyg68ld116", "keyType": null, "_fromUpstream": true, "_orphaned": true }, { "name": "tmp_ProductRaw.UnitCost", "active": false, "dtype": "string", "transform": null, "alias": null, "_srcName": "UnitCost", "_propOriginNodeId": "n78", "_propOriginIdx": "k_mvyg68ld117", "keyType": null, "_fromUpstream": true, "_orphaned": true }, { "name": "tmp_ProductRaw.UnitOfMeasure", "active": false, "dtype": "string", "transform": null, "alias": null, "_srcName": "UnitOfMeasure", "_propOriginNodeId": "n78", "_propOriginIdx": "k_mvyg68ld118", "keyType": null, "_fromUpstream": true, "_orphaned": true }, { "name": "tmp_ProductRaw.Status", "active": false, "dtype": "string", "transform": null, "alias": null, "_srcName": "Status", "_propOriginNodeId": "n78", "_propOriginIdx": "k_mvyg68ld119", "keyType": null, "_fromUpstream": true, "_orphaned": true }, { "name": "tmp_CategoryRaw.CategoryName", "active": false, "dtype": "string", "transform": null, "alias": null, "_srcName": "CategoryName", "_propOriginNodeId": "n78", "_propOriginIdx": "k_mvyg68ld120", "keyType": null, "_fromUpstream": true, "_orphaned": true }, { "name": "tmp_CategoryRaw.Family", "active": false, "dtype": "string", "transform": null, "alias": null, "_srcName": "Family", "_propOriginNodeId": "n78", "_propOriginIdx": "k_mvyg68ld121", "keyType": null, "_fromUpstream": true, "_orphaned": true }, { "name": "BrandName", "active": false, "dtype": "string", "transform": null, "alias": null, "_srcName": "BrandName", "_propOriginNodeId": "n78", "_propOriginIdx": "k_mvyg68ld122", "keyType": null, "_fromUpstream": true, "_orphaned": true }, { "name": "CountryOfOrigin", "active": false, "dtype": "string", "transform": null, "alias": null, "_srcName": "CountryOfOrigin", "_propOriginNodeId": "n78", "_propOriginIdx": "k_mvyg68ld123", "keyType": null, "_fromUpstream": true, "_orphaned": true }, { "name": "ProductName", "_srcName": "ProductName", "active": false, "_fromUpstream": true, "dtype": "string", "_propOriginNodeId": "n78", "_propOriginIdx": "k_mvyg68ld124", "alias": null, "keyType": null, "_orphaned": true }, { "name": "MarginPct", "_srcName": "MarginPct", "active": false, "_fromUpstream": true, "dtype": "string", "_propOriginNodeId": "n78", "_propOriginIdx": "k_mvyg68ld126", "alias": null, "keyType": null, "_orphaned": true }, { "name": "ValidFromDate", "_srcName": "ValidFromDate", "active": false, "dtype": "string", "_propOriginNodeId": "n78", "alias": null, "keyType": null, "_fromUpstream": true, "_propOriginIdx": "k_mvyg68ld127", "_orphaned": true }, { "name": "ValidToDate", "_srcName": "ValidToDate", "active": false, "dtype": "string", "_propOriginNodeId": "n78", "alias": null, "keyType": null, "_fromUpstream": true, "_propOriginIdx": "k_mvyg68ld128", "_orphaned": true }, { "name": "Rate", "active": true, "dtype": "string", "transform": null, "alias": null, "_srcName": "Rate", "_propOriginNodeId": "n78", "_propOriginIdx": "k_mvyg68ld129", "keyType": null, "_fromUpstream": true, "_orphaned": false }, { "name": "ChannelName", "_srcName": "ChannelName", "active": true, "_fromUpstream": true, "dtype": "string", "_propOriginNodeId": "n78", "_propOriginIdx": "x_mvyg68ld132", "alias": null, "keyType": null, "_orphaned": false }, { "name": "NetAmount", "_srcName": "NetAmount", "active": true, "_fromUpstream": true, "dtype": "string", "_propOriginNodeId": "n78", "_propOriginIdx": "x_mvyg68ld133", "alias": null, "keyType": null, "_orphaned": false }, { "name": "NetAmountCOP", "_srcName": "NetAmountCOP", "active": true, "dtype": "string", "_propOriginNodeId": "n113", "alias": null, "keyType": null, "_viaOp": true, "_fromUpstream": true, "_propOriginIdx": "k_mvyg68ld95", "_orphaned": false }, { "name": "FromAmount", "_srcName": "FromAmount", "active": false, "dtype": "string", "_propOriginNodeId": "n113", "alias": null, "keyType": null, "_viaOp": true, "_fromUpstream": true, "_propOriginIdx": "k_mvyg68ld96", "_orphaned": true }, { "name": "ToAmount", "_srcName": "ToAmount", "active": false, "dtype": "string", "_propOriginNodeId": "n113", "alias": null, "keyType": null, "_viaOp": true, "_fromUpstream": true, "_propOriginIdx": "k_mvyg68ld97", "_orphaned": true }, { "name": "AmountBand", "active": true, "dtype": "string", "transform": null, "alias": null, "_viaOp": true, "_srcName": "Band", "_propOriginNodeId": "n113", "_propOriginIdx": "k_mvyg68ld98", "keyType": null, "_fromUpstream": true, "_orphaned": false } ], "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": [], "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": "", "noConcatenate": true, "useWildcard": true, "_reLine": 265 }, "n107": { "id": "n107", "layer": "drop", "label": "Drop_7", "customName": "", "x": 2448, "y": 508, "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": [ "n78" ], "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": "", "_reLine": 270 }, "n109": { "id": "n109", "layer": "raw", "label": "tmp_AmountBand", "customName": "", "x": 2550, "y": 548, "srcLibId": null, "srcType": "txt", "path": "$(vPathRaw)AmountBands.csv", "dest": "", "desc": "", "fields": "*", "where": "", "devComment": "", "opType": "", "transforms": [], "calcFields": [], "columns": [ { "name": "FromAmount", "active": true, "dtype": "string", "transform": null, "alias": null, "_cid": "k_mvyg68lc92" }, { "name": "ToAmount", "active": true, "dtype": "string", "transform": null, "alias": null, "_cid": "k_mvyg68ld93" }, { "name": "Band", "active": true, "dtype": "string", "transform": null, "alias": "AmountBand", "_cid": "k_mvyg68ld94" } ], "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": "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": "", "delim": ",", "csvUtf8": true, "csvMsq": true, "noConcatenate": false, "useWildcard": false, "_reLine": 273 }, "n111": { "id": "n111", "layer": "intervalmatch", "label": "tmp_BandBridge", "customName": "", "x": 2730, "y": 508, "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": "NetAmountCOP", "imStartCol": "FromAmount", "imEndCol": "ToAmount", "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": 277 }, "n113": { "id": "n113", "layer": "txf", "label": "tmp_SaleBand", "customName": "", "x": 2884, "y": 548, "srcLibId": null, "srcType": null, "path": "", "dest": "", "desc": "", "fields": "*", "where": "", "devComment": "", "opType": "", "transforms": [], "calcFields": [], "columns": [ { "name": "NetAmountCOP", "_srcName": "NetAmountCOP", "active": true, "dtype": "string", "_propOriginNodeId": "n111", "alias": null, "keyType": null, "_cid": "k_mvyg68ld95", "_declared": true, "_orphaned": false }, { "name": "FromAmount", "_srcName": "FromAmount", "active": true, "dtype": "string", "_propOriginNodeId": "n111", "alias": null, "keyType": null, "_cid": "k_mvyg68ld96", "_declared": true, "_orphaned": false }, { "name": "ToAmount", "_srcName": "ToAmount", "active": true, "dtype": "string", "_propOriginNodeId": "n111", "alias": null, "keyType": null, "_cid": "k_mvyg68ld97", "_declared": true, "_orphaned": false }, { "name": "AmountBand", "active": true, "dtype": "string", "transform": null, "alias": null, "_cid": "k_mvyg68ld98", "_viaOp": true, "_srcName": "Band", "_propOriginNodeId": "n109", "_propOriginIdx": "k_mvyg68ld94", "keyType": null, "_fromUpstream": true, "_orphaned": false } ], "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": "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": "", "noConcatenate": true, "useWildcard": false, "_reLine": 282 }, "n115": { "id": "n115", "layer": "op", "label": "LEFT JOIN_5", "customName": "", "x": 2550, "y": 815, "srcLibId": null, "srcType": null, "path": "", "dest": "", "desc": "", "fields": "*", "where": "", "devComment": "", "opType": "LEFT JOIN", "transforms": [], "calcFields": [], "columns": [], "showColumns": false, "joinSrc": "", "joinFields": "*", "joinType": "LEFT JOIN", "joinMode": "JOIN", "joinResultResident": true, "joinResultName": "", "forceInlineIds": [ "n118" ], "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": "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": 287 }, "n118": { "id": "n118", "layer": "txf", "label": "tmp_AmountBand_Filtered", "customName": "tmp_AmountBand_Filtered", "x": 2884, "y": 637, "srcLibId": null, "srcType": null, "path": "", "dest": "", "desc": "", "fields": "*", "where": "", "devComment": "", "opType": "", "transforms": [], "calcFields": [], "columns": [ { "name": "FromAmount", "active": true, "dtype": "string", "transform": null, "alias": null, "_srcName": "FromAmount", "_propOriginNodeId": "n109", "_propOriginIdx": "k_mvyg68lc92", "keyType": null, "_declared": true, "_fromUpstream": true, "_orphaned": false }, { "name": "ToAmount", "active": true, "dtype": "string", "transform": null, "alias": null, "_srcName": "ToAmount", "_propOriginNodeId": "n109", "_propOriginIdx": "k_mvyg68ld93", "keyType": null, "_declared": true, "_fromUpstream": true, "_orphaned": false }, { "name": "AmountBand", "active": true, "dtype": "string", "transform": null, "alias": null, "_srcName": "Band", "_propOriginNodeId": "n109", "_propOriginIdx": "k_mvyg68ld94", "keyType": null, "_declared": true, "_fromUpstream": true, "_orphaned": false } ], "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": "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": "", "whereEnabled": false, "groupBy": "", "groupByEnabled": false, "orderBy": "", "orderByEnabled": false, "distinct": false, "useWildcard": false, "copyOf": "n109", "copyWasEmbedded": false }, "n120": { "id": "n120", "layer": "op", "label": "LEFT JOIN_6", "customName": "", "x": 3408, "y": 548, "srcLibId": null, "srcType": null, "path": "", "dest": "", "desc": "", "fields": "*", "where": "", "devComment": "", "opType": "LEFT JOIN", "transforms": [], "calcFields": [], "columns": [], "showColumns": false, "joinSrc": "", "joinFields": "*", "joinType": "LEFT JOIN", "joinMode": "JOIN", "joinResultResident": true, "joinResultName": "", "forceInlineIds": [ "n123" ], "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": "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": 291 }, "n123": { "id": "n123", "layer": "txf", "label": "tmp_SaleBand_Filtered", "customName": "tmp_SaleBand_Filtered", "x": 3166, "y": 548, "srcLibId": null, "srcType": null, "path": "", "dest": "", "desc": "", "fields": "*", "where": "", "devComment": "", "opType": "", "transforms": [], "calcFields": [], "columns": [ { "name": "NetAmountCOP", "_srcName": "NetAmountCOP", "active": true, "dtype": "string", "_propOriginNodeId": "n113", "alias": null, "keyType": null, "_fromUpstream": true, "_propOriginIdx": "k_mvyg68ld95", "_declared": true, "_orphaned": false }, { "name": "FromAmount", "_srcName": "FromAmount", "active": false, "dtype": "string", "_propOriginNodeId": "n113", "alias": null, "keyType": null, "_fromUpstream": true, "_propOriginIdx": "k_mvyg68ld96", "_orphaned": false }, { "name": "ToAmount", "_srcName": "ToAmount", "active": false, "dtype": "string", "_propOriginNodeId": "n113", "alias": null, "keyType": null, "_fromUpstream": true, "_propOriginIdx": "k_mvyg68ld97", "_orphaned": false }, { "name": "AmountBand", "active": true, "dtype": "string", "transform": null, "alias": null, "_srcName": "Band", "_propOriginNodeId": "n113", "_propOriginIdx": "k_mvyg68ld98", "keyType": null, "_fromUpstream": true, "_declared": true, "_orphaned": false } ], "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": "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": "", "whereEnabled": false, "groupBy": "", "groupByEnabled": false, "orderBy": "", "orderByEnabled": false, "distinct": false, "useWildcard": false, "copyOf": "n113", "copyWasEmbedded": false }, "n125": { "id": "n125", "layer": "drop", "label": "Drop_8", "customName": "", "x": 3588, "y": 508, "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": [ "n111", "n113", "n109" ], "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": "", "_reLine": 295 }, "n127": { "id": "n127", "layer": "drop", "label": "Drop_9", "customName": "", "x": 3642, "y": 508, "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": [ "n105::SourceFile" ], "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": 297 }, "n129": { "id": "n129", "layer": "chk", "label": "Sales_2", "customName": "", "x": 2502, "y": 608, "srcLibId": null, "srcType": null, "path": "", "dest": "$(vTxfPath)Sales_Check.qvd", "desc": "", "fields": "*", "where": "", "devComment": "", "opType": "CHECKPOINT", "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": "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": "", "chkStore": true, "chkExitScript": true, "_reLine": 305 }, "n131": { "id": "n131", "layer": "chk", "label": "Checkpoint", "customName": "", "x": 2448, "y": 608, "srcLibId": null, "srcType": null, "path": "", "dest": "$(vTxfPath)Sales.qvd", "desc": "", "fields": "*", "where": "", "devComment": "", "opType": "CHECKPOINT", "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": "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": 299 }, "n149": { "id": "n149", "layer": "drop", "label": "Drop_10", "customName": "", "x": 502, "y": 1051, "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": [ "n22" ], "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": "" }, "n151": { "id": "n151", "layer": "drop", "label": "Drop_11", "customName": "", "x": 502, "y": 1231, "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": [ "n25" ], "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": "" }, "n153": { "id": "n153", "layer": "drop", "label": "Drop_12", "customName": "", "x": 502, "y": 1411, "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": [ "n28" ], "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": "" } }, "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": "n13", "to": "n15", "qeReSequential": true, "id": "c16" }, { "from": "n15", "to": "n17", "id": "c18" }, { "from": "n17", "to": "n19", "id": "c20" }, { "from": "n22", "to": "n21", "id": "c23" }, { "from": "n25", "to": "n24", "id": "c26" }, { "from": "n28", "to": "n27", "id": "c29" }, { "from": "n31", "to": "n32", "id": "c33" }, { "from": "n32", "to": "n34", "id": "c35" }, { "from": "n34", "to": "n36", "qeReSequential": true, "id": "c37" }, { "from": "n41", "to": "n42", "id": "c43" }, { "from": "n42", "to": "n44", "qeReSequential": true, "id": "c45" }, { "from": "n36", "to": "n46", "id": "c47" }, { "from": "n46", "to": "n48", "id": "c49" }, { "from": "n46", "to": "n50", "id": "c51" }, { "from": "n50", "to": "n52", "id": "c53" }, { "from": "n52", "to": "n54", "qeReSequential": true, "id": "c55" }, { "from": "n56", "to": "n50", "id": "c57" }, { "from": "n54", "to": "n56", "id": "c58" }, { "from": "n38", "to": "n59", "id": "c60" }, { "from": "n61", "to": "n59", "id": "c62" }, { "from": "n41", "to": "n64", "id": "c63" }, { "id": "c65", "from": "n64", "to": "n61" }, { "from": "n44", "to": "n67", "id": "c66" }, { "id": "c68", "from": "n67", "to": "n61" }, { "from": "n39", "to": "n69", "id": "c70" }, { "from": "n3", "to": "n71", "id": "c72" }, { "from": "n71", "to": "n69", "id": "c73" }, { "from": "n40", "to": "n74", "id": "c75" }, { "from": "n74", "to": "n76", "id": "c77" }, { "from": "n3", "to": "n78", "id": "c79" }, { "from": "n78", "to": "n80", "id": "c81" }, { "from": "n82", "to": "n78", "id": "c83" }, { "from": "n59", "to": "n85", "id": "c84" }, { "id": "c86", "from": "n85", "to": "n82" }, { "from": "n87", "to": "n88", "id": "c89" }, { "from": "n88", "to": "n90", "id": "c91" }, { "from": "n92", "to": "n90", "id": "c93" }, { "from": "n87", "to": "n95", "id": "c94" }, { "id": "c96", "from": "n95", "to": "n92" }, { "from": "n98", "to": "n78", "id": "c99" }, { "from": "n90", "to": "n101", "id": "c100" }, { "id": "c102", "from": "n101", "to": "n98" }, { "from": "n98", "to": "n103", "id": "c104" }, { "from": "n78", "to": "n105", "id": "c106" }, { "from": "n105", "to": "n107", "id": "c108" }, { "from": "n107", "to": "n109", "qeReSequential": true, "id": "c110" }, { "from": "n109", "to": "n111", "id": "c112" }, { "from": "n111", "to": "n113", "id": "c114" }, { "from": "n115", "to": "n113", "id": "c116" }, { "from": "n109", "to": "n118", "id": "c117" }, { "id": "c119", "from": "n118", "to": "n115" }, { "from": "n120", "to": "n105", "id": "c121" }, { "from": "n113", "to": "n123", "id": "c122" }, { "id": "c124", "from": "n123", "to": "n120" }, { "from": "n120", "to": "n125", "id": "c126" }, { "from": "n125", "to": "n127", "id": "c128" }, { "from": "n131", "to": "n129", "id": "c130" }, { "from": "n105", "to": "n131", "id": "c132" }, { "from": "n15", "to": "n19", "id": "c133" }, { "from": "n46", "to": "n52", "id": "c134" }, { "from": "n36", "to": "n76", "id": "c135" }, { "from": "n38", "to": "n76", "id": "c136" }, { "from": "n39", "to": "n76", "id": "c137" }, { "from": "n40", "to": "n76", "id": "c138" }, { "from": "n41", "to": "n76", "id": "c139" }, { "from": "n44", "to": "n76", "id": "c140" }, { "from": "n3", "to": "n80", "id": "c141" }, { "from": "n88", "to": "n103", "id": "c142" }, { "from": "n90", "to": "n103", "id": "c143" }, { "from": "n87", "to": "n103", "id": "c144" }, { "from": "n78", "to": "n107", "id": "c145" }, { "from": "n111", "to": "n125", "id": "c146" }, { "from": "n113", "to": "n125", "id": "c147" }, { "from": "n109", "to": "n125", "id": "c148" }, { "from": "n21", "to": "n149", "id": "c150" }, { "from": "n24", "to": "n151", "id": "c152" }, { "from": "n27", "to": "n153", "id": "c154" } ], "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" } } }