{
  "version": "5.9.1",
  "className": "datameer.dap.common.entity.WorkbookConfigurationImpl",
  "file": {
    "uuid": "95f2ea83-45d0-41d2-9fdf-c03d03b0dcb9",
    "path": "/Users/admin/Transpose.wbk",
    "description": "",
    "name": "Transpose"
  },
  "pullType": "MANUALLY",
  "minKeepCount": 1,
  "properties": {},
  "hadoopProperties": "",
  "notificationAddresses": "",
  "notificationSuccessAddresses": "",
  "sheets": [
    {
      "name": "Names",
      "sheetId": "78611961-3cfe-4673-a3ec-4db28d0b9ea4",
      "sheetType": "das.internal.FormulaSheetType",
      "keep": false,
      "formulas": [
        {
          "columnName": "Names",
          "columnId": "0",
          "columnIndex": 0,
          "formulaString": "\u003dCHAR(EXPLODE_RANGE(65;90))"
        },
        {
          "columnName": "n",
          "columnId": "3",
          "columnIndex": 1,
          "formulaString": "\u003dINT(RANDBETWEEN(0;10))"
        }
      ],
      "columnStyles": [
        {
          "columnId": "0",
          "name": "Names",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "3",
          "name": "n",
          "width": 100,
          "thousandSeparator": true
        }
      ],
      "nextColumnId": 4
    },
    {
      "name": "NamesPrepareToGroup",
      "sheetId": "cd92d829-6fe7-42d0-9ec4-76cd0860fb45",
      "sheetType": "das.internal.FormulaSheetType",
      "keep": true,
      "formulas": [
        {
          "columnName": "dummyGroupNo",
          "columnId": "2",
          "columnIndex": 0,
          "formulaString": "\u003d1"
        },
        {
          "columnName": "Names",
          "columnId": "0",
          "columnIndex": 1,
          "formulaString": "\u003d#Names!Names"
        },
        {
          "columnName": "n",
          "columnId": "1",
          "columnIndex": 2,
          "formulaString": "\u003d#Names!n"
        }
      ],
      "columnStyles": [
        {
          "columnId": "0",
          "name": "Names",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "1",
          "name": "n",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "2",
          "name": "dummyGroupNo",
          "width": 147,
          "thousandSeparator": true
        }
      ],
      "nextColumnId": 3
    },
    {
      "name": "NamesGrouped",
      "sheetId": "49afa041-1455-4a02-892b-701580d6d7b1",
      "sheetType": "das.internal.FormulaSheetType",
      "keep": true,
      "formulas": [
        {
          "columnName": "NamesGrouped",
          "columnId": "0",
          "columnIndex": 0,
          "formulaString": "\u003dGroupBy(#NamesPrepareToGroup!dummyGroupNo)"
        },
        {
          "columnName": "NamesConcat",
          "columnId": "1",
          "columnIndex": 1,
          "formulaString": "\u003dGROUPCONCAT(#NamesPrepareToGroup!Names)"
        },
        {
          "columnName": "nConcat",
          "columnId": "3",
          "columnIndex": 2,
          "formulaString": "\u003dGROUPCONCAT(#NamesPrepareToGroup!n)"
        }
      ],
      "columnStyles": [
        {
          "columnId": "0",
          "name": "NamesGrouped",
          "width": 136,
          "thousandSeparator": true
        },
        {
          "columnId": "1",
          "name": "NamesConcat",
          "width": 176,
          "thousandSeparator": true
        },
        {
          "columnId": "3",
          "name": "nConcat",
          "width": 172,
          "thousandSeparator": true
        }
      ],
      "nextColumnId": 5
    }
  ],
  "advancedSchedulingInUse": true,
  "errorHandlingMode": "IGNORE"
}