Create map from excel columns

Hello everyone!
Is there a way in KNIME to create map from excel columns?
So far I have this in my excel:
image

And I want to get it looks like this this:
“items”: [
{
“grossAmount” : 1080,
“netAmount”: 1000
}
]

Hi @denajaha -

Have you tried reading the data into a KNIME table, then applying the Table to JSON node?

1 Like

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.