Insert square brackets and double quotes to a string
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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?

- « Previous
-
- 1
- 2
- Next »