table to nested JSON

KNIME Analytics Platform
1

Hi Commynity, I need your help!! :slight_smile:

I’m trying to convert the following table into a nested json but I cant figure out how :frowning: The structure should be following:

Company1
------Date
---------Turnover
----------Ebit
----------EBITDA
----------Net debt
--------Date 2
----------Turnover
…

The table structure is as below. Can anyone help with this, please? :pray:

Company Date Turnover EBIT EBITDA Net debt
Company 1 30.3.3020 1132 2344 546 4564
Company 1 30.6.2020 3242 23423 45645 4566
Company 1 30.3.3021 234234 2343 456 45665
Company 1 30.6.2021 23423 23423 4566 45645
Company 1 30.3.3022 2342 2323 564 54645
Company 1 30.6.2022 234 234 56 45664
Company 1 30.3.3023 2343 23 456 4565456
Company 1 30.6.2023 23423 645 456 4565
2

Hi @Data_processor ,

basically you do this step by step. First, build the innermost layer, than the next layer, until you reach the outermost layer. Here is a small example: 87071 Nested JSON – KNIME Community Hub

image
image1348×347 26.1 KB

Hope this helps,
nan

5 Likes