Hub
NodeNode / Manipulator

Ungroup

Streamable Manipulation Row Transform
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. 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
  8. 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
  9. OnePagePerLine
    BIRT Powerpoint Pptx
    BIRT Example for adding one page per line
    iris > Public > ExamplesForTheForum > OnePagePerLine
  10. Z_023_Cell splitting
    tommy > Public > Z_023_Cell splitting