Convert Table To JSON

Alc2020

Hi,

I have the following table.

		home_address
first_name	last_name	address_line1	address_line2	city	state	zip	country
John	Doe	#123 Street 123	Suite 123	Brooklyn	New York	12312	US
Name2
and so on

How can I make this into a JSON output like below?

{
  "first_name": "John",
  "last_name": "Doe",
  "home_address": {
    "address_line1": "#123 Streat 123",
    "address_line2": "Suite 123",
    "city": "Brooklyn",
    "state": "New York",
    "zip": "12312",
    "country": "US"
  }
}

Thank you very much.

Christine_Assaad

Hi @Alc2020 

Please check the attached. I built a hierarchy for the address to appear the way you want it. Hope it helps. Cheers!

Convert Table to Json.yxmd