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.
Solved! Go to Solution.
Hi @Alc2020
Please check the attached. I built a hierarchy for the address to appear the way you want it. Hope it helps. Cheers!
hi @Alc2020 ,
We have Json build tool that can do that. Check out the workflow attached. Does this format work for you?
Thank you very much for your help!