Insert square brackets and double quotes to a string

[spuri5]

Hello Alteryx Community,

My current output is looking like this in JSON format as shown below:

Current Output 1
"Name": "AAA","BBB","CCC"

Current Output 2
"Name":""

Current Output 3
"Name":"HHH"

The expected output should be like as shown below:

Expected Output1
"Name": ["AAA","BBB","CCC"]

Expected Output2
"Name": [""]

Expected Output3
"Name": ["HHH"]

Thank you!

[Matt_D]

Hi @spuri5 I'm not 100% sure what you're after here but if you're looking to turn your Excel data into JSON, use the JSON Build Tool

Is this what you're after?

If it's just the specific strings highlighted then I would parse to rows using the comma then use the concatenate function in the Summary Tool to bring it back together, that way it's dynamic.

[CathyS_Slalom]

Hi @spuri5, not sure what steps that you've done before you need insert brackets, could you share a sample workflow for us to work on?