Hello, I am stuck in a predicament. I have correlation data in table format which needs to be converted to a JSON with a particular structure, dynamically, as the table format (ie. the column names and the values) change depending on the customer. Input format : [image] heatmapdata.xlsx (22.2 KB) Output format: [image] [image] JSON Blob | 67e435c1-af38-11ea-8ded-bd5e632e6f30 I find no approach which will help me out in this. test_heatmap-to-json.knwf (19.8 KB) PS. @ipazin , just putting you on here because i have seen how active you are and i believe you can help. Thank you.

table to JSON with structure

ipazin June 17, 2020, 10:11am 4

not sure I can help or suggest more than I did in this topic:

Please don’t open multiple topics for same issue.

Br,
Ivan

1 Like