{
  "version": "5.7.1",
  "className": "datameer.dap.common.entity.WorkbookConfigurationImpl",
  "file": {
    "uuid": "1984bc70-159f-4970-bb67-d1f2bc7e59bd",
    "path": "/Analytics/Workbooks/DenseRank.wbk",
    "description": "",
    "name": "DenseRank"
  },
  "pullType": "MANUALLY",
  "minKeepCount": 1,
  "properties": {},
  "hadoopProperties": "",
  "notificationAddresses": "",
  "notificationSuccessAddresses": "",
  "sheets": [
    {
      "name": "Source",
      "sheetId": "5b810730-df92-44cc-9699-d40ee1a0a139",
      "sheetType": "das.internal.FormulaSheetType",
      "keep": true,
      "formulas": [
        {
          "columnName": "Key",
          "columnId": "1",
          "columnIndex": 0,
          "formulaString": "\u003dEXPAND([\"a\"])"
        },
        {
          "columnName": "Value",
          "columnId": "2",
          "columnIndex": 1,
          "formulaString": "\u003dEXPAND(LIST(\"1\";\"1\";\"2\";\"4\";\"4\";\"5\";\"5\";\"5\";\"6\"))"
        }
      ],
      "columnStyles": [
        {
          "columnId": "1",
          "name": "Key",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "2",
          "name": "Value",
          "width": 100,
          "thousandSeparator": true
        }
      ],
      "nextColumnId": 3
    },
    {
      "name": "RankListTraditional",
      "sheetId": "a1413454-4b32-4a7b-a0ae-c57658b52526",
      "sheetType": "das.internal.FormulaSheetType",
      "keep": true,
      "formulas": [
        {
          "columnName": "ID",
          "columnId": "0",
          "columnIndex": 0,
          "formulaString": "\u003dGROUPBY(#Source!Key)"
        },
        {
          "columnName": "VALUE_LIST",
          "columnId": "1",
          "columnIndex": 1,
          "formulaString": "\u003dSORT(GROUPCONCAT(#Source!Value))"
        },
        {
          "columnName": "VALUE",
          "columnId": "2",
          "columnIndex": 2,
          "formulaString": "\u003dEXPAND(#VALUE_LIST)"
        },
        {
          "columnName": "RANK",
          "columnId": "3",
          "columnIndex": 3,
          "formulaString": "\u003dINDEXOF(#VALUE_LIST;#VALUE)+1"
        }
      ],
      "columnStyles": [
        {
          "columnId": "0",
          "name": "ID",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "1",
          "name": "VALUE_LIST",
          "width": 219,
          "thousandSeparator": true
        },
        {
          "columnId": "2",
          "name": "VALUE",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "3",
          "name": "RANK",
          "width": 100,
          "thousandSeparator": true
        }
      ],
      "nextColumnId": 5
    },
    {
      "name": "DenseRankList",
      "sheetId": "ded0e690-7863-4511-9cc5-8f10144f9e4d",
      "sheetType": "das.internal.FormulaSheetType",
      "keep": true,
      "formulas": [
        {
          "columnName": "ID",
          "columnId": "12",
          "columnIndex": 0,
          "formulaString": "\u003dGROUPBY(#Source!Key)"
        },
        {
          "columnName": "VALUE_LIST",
          "columnId": "13",
          "columnIndex": 1,
          "formulaString": "\u003dGROUPCONCAT(#Source!Value)"
        },
        {
          "columnName": "UNIQUE_VALUE",
          "columnId": "14",
          "columnIndex": 2,
          "formulaString": "\u003dUNIQUES(#VALUE_LIST)"
        },
        {
          "columnName": "VALUE",
          "columnId": "15",
          "columnIndex": 3,
          "formulaString": "\u003dEXPAND(#UNIQUE_VALUE)"
        },
        {
          "columnName": "DENSE_RANK",
          "columnId": "20",
          "columnIndex": 4,
          "formulaString": "\u003dINDEXOF(#UNIQUE_VALUE;#VALUE)+1"
        }
      ],
      "columnStyles": [
        {
          "columnId": "12",
          "name": "ID",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "13",
          "name": "VALUE_LIST",
          "width": 183,
          "thousandSeparator": true
        },
        {
          "columnId": "14",
          "name": "UNIQUE_VALUE",
          "width": 176,
          "thousandSeparator": true
        },
        {
          "columnId": "15",
          "name": "VALUE",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "20",
          "name": "DENSE_RANK",
          "width": 153,
          "thousandSeparator": true
        }
      ],
      "nextColumnId": 22
    },
    {
      "name": "Ranks",
      "sheetId": "3de9f5c6-c97e-4ccc-9b40-cae266a32008",
      "sheetType": "das.internal.JoinedSheetType",
      "keep": true,
      "sheetDefinition": {
        "joinCategory": "TWO_MEMBER_JOIN",
        "joinPairs": [
          {
            "joinType": "INNER",
            "sheet1": "RankListTraditional",
            "sheet2": "DenseRankList",
            "joinColumns1": [
              "ID",
              "VALUE"
            ],
            "joinColumns2": [
              "ID",
              "VALUE"
            ]
          }
        ],
        "sheetToIncludeColumns": {
          "DenseRankList": [
            "DENSE_RANK"
          ],
          "RankListTraditional": [
            "ID",
            "RANK",
            "VALUE"
          ]
        }
      },
      "columnStyles": [
        {
          "columnId": "357996d5f607e683d6d588e46b9a615b",
          "name": "VALUE",
          "width": 141,
          "thousandSeparator": true
        },
        {
          "columnId": "2a6159954e2c7afc9b203207fe76352d",
          "name": "RANK",
          "width": 150,
          "thousandSeparator": true
        },
        {
          "columnId": "fdc20a88c4af9fb3bbcfc2b6e32c9e2b",
          "name": "DENSE_RANK",
          "width": 247,
          "thousandSeparator": true
        },
        {
          "columnId": "2b00881f5ce57d5fe793dd4a438e3eeb",
          "name": "ID",
          "width": 100,
          "thousandSeparator": true
        }
      ]
    },
    {
      "name": "RanksWithRowNumber",
      "sheetId": "5ad08531-eb4e-49c4-960a-83e2dd176006",
      "sheetType": "das.internal.FormulaSheetType",
      "keep": true,
      "formulas": [
        {
          "columnName": "GROUPBY_1",
          "columnId": "4",
          "columnIndex": 0,
          "formulaString": "\u003dGROUPBY(1)"
        },
        {
          "columnName": "ID",
          "columnId": "0",
          "columnIndex": 1,
          "formulaString": "\u003d#Ranks!ID"
        },
        {
          "columnName": "VALUE",
          "columnId": "1",
          "columnIndex": 2,
          "formulaString": "\u003d#Ranks!VALUE"
        },
        {
          "columnName": "ROW_NUMBER",
          "columnId": "5",
          "columnIndex": 3,
          "formulaString": "\u003dGROUPROWNUMBER()"
        },
        {
          "columnName": "RANK",
          "columnId": "2",
          "columnIndex": 4,
          "formulaString": "\u003d#Ranks!RANK"
        },
        {
          "columnName": "DENSE_RANK",
          "columnId": "3",
          "columnIndex": 5,
          "formulaString": "\u003d#Ranks!DENSE_RANK"
        }
      ],
      "columnStyles": [
        {
          "columnId": "0",
          "name": "ID",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "1",
          "name": "VALUE",
          "width": 141,
          "thousandSeparator": true
        },
        {
          "columnId": "2",
          "name": "RANK",
          "width": 150,
          "thousandSeparator": true
        },
        {
          "columnId": "3",
          "name": "DENSE_RANK",
          "width": 247,
          "thousandSeparator": true
        },
        {
          "columnId": "4",
          "name": "GROUPBY_1",
          "width": 116,
          "thousandSeparator": true
        },
        {
          "columnId": "5",
          "name": "ROW_NUMBER",
          "width": 150,
          "thousandSeparator": true
        }
      ],
      "nextColumnId": 6
    }
  ],
  "advancedSchedulingInUse": true,
  "errorHandlingMode": "IGNORE"
}