Skip to content
HALOWERK

File Formats and Conversion

csv long category measures to wide rows

CSV pivot returns one row per key with category values in separate columns. Use it when an agent needs to prepare a wide export from unique long-form records.

POST https://format.halowerk.com/v1/csv-long-category-measures-to-wide-rows

Inputs

Fields of the published input schema
FieldTypeRequiredDescription
textstringYes
keysarrayYes
categorystringYes
value_columnstringYes
Show full input schema
{
  "type": "object",
  "properties": {
    "text": {
      "type": "string",
      "maxLength": 7500,
      "minLength": 1
    },
    "keys": {
      "type": "array",
      "items": {
        "type": "string",
        "maxLength": 90,
        "minLength": 1
      },
      "maxItems": 12,
      "minItems": 1
    },
    "category": {
      "type": "string",
      "maxLength": 90,
      "minLength": 1
    },
    "value_column": {
      "type": "string",
      "maxLength": 90,
      "minLength": 1
    }
  },
  "required": [
    "text",
    "keys",
    "category",
    "value_column"
  ],
  "additionalProperties": false
}

Open original schema

Published input example

{
  "text": "date,type,percent\n2025-09-30,Treasury Bills,4.187\n2025-09-30,Treasury Notes,3.112\n2025-09-30,Treasury Bonds,3.327\n",
  "keys": [
    "date"
  ],
  "category": "type",
  "value_column": "percent"
}

Result & documentation

Machine-readable documentation of this hub

Source of this page: the published HALOWERK catalog. Updated: 2026-11-19 UTC.

More endpoints in this hub

All endpoints in this hub โ†’