excel to json file

[gunay242]

I m trying to convert excel file to json format.

which nodes should I use ?

format shoulb be like this ;

---

[
{
“text”: “text detail”,
“is_retweet”: false,
“datetime”: 1594045044000
},
{
“text”: “text detail”,
“is_retweet”: false,
“datetime”: 1593961701000
},

---

I ve text, is_retweet and datetime columns in excel.

[ipazin]

Hi @gunay242,

after you use Excel Reader (XLS) node to get your data into KNIME you need to use Table to JSON.

Br,
Ivan