Hub
Pricing About
NodeNode / Manipulator

Columns to JSON

Structured DataJSONStreamable
Drag & drop
Like

The columns values are transformed to JSON objects for each row. When there are conflicting keys, the result is undefined, might vary between different versions of KNIME.

An example transformation:
From table:

MainNumtextmain12Hellomain21World

with custom key/values: const and val , Main as data bound key, Num with manual num key and text as automatic:

{"main1":{"text": "Hello", "num": 2, "const":"val"}}{"main2":{"text": "World", "num": 1, "const":"val"}}

Node details

Input ports
  1. Type: Table
    Table
    Table with values.
Output ports
  1. Type: Table
    Table with JSON
    Table with the row-wise generated JSON column.

Extension

The Columns to JSON node is part of this extension:

  1. Go to item

Related workflows & nodes

  1. Go to item
  2. Go to item
  3. Go to item

KNIME
Open for Innovation

KNIME AG
Talacker 50
8001 Zurich, Switzerland
  • Software
  • Getting started
  • Documentation
  • Courses + Certification
  • Solutions
  • KNIME Hub
  • KNIME Forum
  • Blog
  • Events
  • Partner
  • Developers
  • KNIME Home
  • Careers
  • Contact us
Download KNIME Analytics Platform Read more about KNIME Business Hub
© 2025 KNIME AG. All rights reserved.
  • Trademarks
  • Imprint
  • Privacy
  • Terms & Conditions
  • Data Processing Agreement
  • Credits