How to create JSON from multiple columns

[Sshasnk]

Hi I have 3 columns I have to create JSON So I can push it into an API, Below is the example

Input

Vender	Fruits	State
Jhon	Apple	NYC
Rick	Mango	TKY
Matt	Banana	LND

Output:

Vender	Fruits	State	JSON
Jhon	Apple	NYC	{ "Vender": "Jhon", "Fruits": "Apple", "State":"NYC" }
Rick	Mango	TKY	{ "Vender": "Rick", "Fruits": "Mango", "State":"TKY" }
Matt	Banana	LND	{ "Vender": "Matt", "Fruits": "Banana", "State":"LND" }

Let me know if there is any other to construct JSON

[JosephSerpis]

Hi @Sshasnk I mocked up a workflow that produces the output you describe. Let me know what you think?

[Sshasnk]

@JosephSerpis  I also need the field names vender fruit, and State. Your solution is giving only JSON column 

[JosephSerpis · Accepted solution]

Hi @Sshasnk I amended the workflow and attached the original fields back on.