Hub
NodeNode / Manipulator

Ungroup

Manipulation Row Transform Streamable
Drag & drop
Like
Copy short link

Creates for each list of collection values a list of rows with the values of the collection in one column and all other columns given from the original row. Rows with an empty collection are skipped, as well as rows that contain only missing values in the collection cell with the 'Skip missing values' option enabled.

Node details

Input ports
  1. Type: Table
    Data table
    The input table to ungroup
Output ports
  1. Type: Table
    Data table
    Ungrouped table

Extension

The Ungroup node is part of this extension:

Related workflows & nodes

  1. Accessing GitHub API
    stelfrich > Public > Accessing GitHub API
    stelfrich
  2. Forum_Question_Access_JSON_Table_Via_Get_Request
    kathrin > Public > Forum_Questions > Forum_Question_Access_JSON_Table_Via_Get_Request
    kathrin
  3. COVID-19 SARS-CoV-2 preprints from medRxiv and bioRxiv
    MedRxiv BioRxiv
    https://connect.medrxiv.org/relate/collection_json.php?grp=181 The URL linked above outpu…
    tymsk3891 > Public > medRxiv > COVID-19 SARS-CoV-2 preprints from medRxiv and bioRxiv
    tymsk3891
  4. XPath webpage table extraction
    elsamuel > Public > XPath webpage table extraction
    elsamuel
  5. 20220915 Pikairos Adding columns into one column
    This workflow shows how to Aggregate columns as a set and then how to ungroup them
    pikairos > Public > 20220915 Pikairos Adding columns into one column
    pikairos
  6. KNIME List Mountpoints
    Lists the identifiers + classes of "mount points" added to KNIME Explorer (in versions 4.…
    wiswedel > Public > KNIME List Mountpoints
    wiswedel
  7. Random combination of data tables
    Data generation
    This workflow combines two tables randomly. Here, the rows of table 1 are randomly filled…
    knime > Examples > 01_Data_Access > 03_Data_Generation > 06_Random_combination_of_two_sets_of_data
    knime
  8. All in One Row
    One Row Data Manipulation
    This workflow transforms input table with n rows and m columns to 1 row and n times m col…
    ipazin > Public > 2019_09_05_All_in_One_Row
    ipazin
  9. Split Numbers vs Strings
    Data Manipulation RegEx
    This workflow demonstates how to split number against string values from same column and …
    ipazin > Public > 2020_08_05_Split_Numbers_vs_Strings
    ipazin
  10. JSON simple example to extract data via Path
    Json Path Xml
    +1
    JSON simple example to extract data via Path
    mlauber71 > Public > kn_example_json_simple
    mlauber71