Hi I have 3 columns I have to create JSON So I can push it into an API, Below is the example Input Vender FruitsStateJhonAppleNYCRickMangoTKYMattBananaLND Output: Vender FruitsStateJSONJhonAppleNYC{ "Vender": "Jhon", "Fruits": "Apple", "State":"NYC" } RickMangoTKY{ "Vender": "Rick", "Fruits": "Mango", "State":"TKY" } MattBananaLND{ "Vender": "Matt", "Fruits": "Banana", "State":"LND" } Let me know if there is any other to construct JSON

How to create JSON from multiple columns

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

Input

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

Developer

API

Help

Download

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

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

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