I want to parse list row data in each column, how can I do it?

[turkekulbekir]

Hi there,

I am very new in Knime and Data Science. I searched a lot, but could not find a similar topic which could help me to solve my problem.

I want to parse list row data in each column, how can I do it?

I’m sharing the sample table below. Thanks in advance.
sample_workflow.knwf (86.3 KB)

[duristef]

hi @turkekulbekir if this is the result you need

you must

• change the settings in Json to Table node: select “Keep as collection elements”
• add a Ungroup node and include all the list columns you need
  Hope this suggestion is helpful

[turkekulbekir]

Thanks for the solution @duristef , actually my table consisted of a Json Path (dictionary) not json, but here I resolved the issue by converting my table to json and then converting the json back to a table. Thank you very much for your support.