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
  2. Forum_Question_Access_JSON_Table_Via_Get_Request
    kathrin > Public > Forum_Questions > Forum_Question_Access_JSON_Table_Via_Get_Request
  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
  4. 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
  5. 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
  6. 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
  7. 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
  8. KnimeIT_14
    Justknimeit-14
    There has been no description set for this workflow's metadata.
    mepivnenko > Public > KnimeIT_14
  9. Working With Collections - Collection Types
    ETL Collection Collection types
    The goal of the workflow is to demonstrate the creation and working with collection cells…
    knime > Examples > 02_ETL_Data_Manipulation > 02_Aggregations > 03_Working_with_Collection_Supported_Types
  10. Multiple Reports Child Workflow
    Reporting Child Workflow Called Workflow
    +2
    This is child workflow or called workflow meaning it gets called from another workflow. I…
    ipazin > Public > Multiple Reports > 2020_08_10_Multiple_Reports_Child_Workflow