{
  "version": "5.7.27",
  "className": "datameer.dap.common.entity.WorkbookConfigurationImpl",
  "file": {
    "uuid": "ed3fb25b-5fec-46a0-9f46-399ba8a40d52",
    "path": "/Analytics/Tests/GROUP_FILL_DOWN.wbk",
    "description": "",
    "name": "GROUP_FILL_DOWN"
  },
  "pullType": "MANUALLY",
  "minKeepCount": 1,
  "properties": {},
  "notificationAddresses": "",
  "notificationSuccessAddresses": "",
  "sheets": [
    {
      "name": "GROUP_FILL_DOWN",
      "sheetId": "1eb2ed98-8f6f-4a5d-90f0-57ead3f21614",
      "sheetType": "das.internal.DataSourceSheetType",
      "keep": false,
      "datasource": {
        "path": "/Analytics/Tests/GROUP_FILL_DOWN.upl",
        "uuid": "80b6ffdd-165c-4720-8afe-91dff9beece0"
      },
      "columnStyles": []
    },
    {
      "name": "Data",
      "sheetId": "2c19d57d-3762-4c0c-86f0-a26cd7c12e63",
      "sheetType": "das.internal.FormulaSheetType",
      "keep": false,
      "formulas": [
        {
          "columnName": "Name",
          "columnId": "0",
          "columnIndex": 0,
          "formulaString": "\u003dGROUPBY(#GROUP_FILL_DOWN!A)"
        },
        {
          "columnName": "Account",
          "columnId": "1",
          "columnIndex": 1,
          "formulaString": "\u003dGROUPBY(#GROUP_FILL_DOWN!B)"
        },
        {
          "columnName": "Row_Number",
          "columnId": "2",
          "columnIndex": 2,
          "formulaString": "\u003dGROUPROWNUMBER()"
        }
      ],
      "columnStyles": [
        {
          "columnId": "0",
          "name": "Name",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "1",
          "name": "Account",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "2",
          "name": "Row_Number",
          "width": 100,
          "thousandSeparator": true
        }
      ],
      "nextColumnId": 3
    },
    {
      "name": "PostProcess",
      "sheetId": "18ca30f1-a076-4fe3-aa4c-6a939966909b",
      "sheetType": "das.internal.FormulaSheetType",
      "keep": false,
      "formulas": [
        {
          "columnName": "Name",
          "columnId": "0",
          "columnIndex": 0,
          "formulaString": "\u003dGROUPBY(#Data!Name)"
        },
        {
          "columnName": "Account",
          "columnId": "1",
          "columnIndex": 1,
          "formulaString": "\u003dGROUPMAX(#Data!Account)"
        }
      ],
      "columnStyles": [
        {
          "columnId": "0",
          "name": "Name",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "1",
          "name": "Account",
          "width": 100,
          "thousandSeparator": true
        }
      ],
      "nextColumnId": 2
    },
    {
      "name": "JoinedSheet",
      "sheetId": "2a387b9a-5c7b-452c-914f-c78ede1b1061",
      "sheetType": "das.internal.JoinedSheetType",
      "keep": true,
      "sheetDefinition": {
        "joinCategory": "TWO_MEMBER_JOIN",
        "joinPairs": [
          {
            "joinType": "INNER",
            "sheet1": "Data",
            "sheet2": "PostProcess",
            "joinColumns1": [
              "Name"
            ],
            "joinColumns2": [
              "Name"
            ]
          }
        ],
        "sheetToIncludeColumns": {
          "Data": [
            "Name"
          ],
          "PostProcess": [
            "Account"
          ]
        }
      },
      "columnStyles": []
    }
  ],
  "advancedSchedulingInUse": true,
  "errorHandlingMode": "IGNORE"
}