JSON build

Question

I’m using the Alteryz JSON build tool to build an array of JSON objects.   I’m reading from a CSV file and I can set Fields and I would like the Record # to be stored in a variable to be used to build my JSON array so they can be grouped together (Record.0.Address) to build my Jason array. Currently it’s not building as an array but instead as one big json object. Attached is my workflow. Does anyone know a best way to build a JSON object array?

json output.yxmd

TashaA · Accepted Answer

Hey @mdata,

I have attached a workflow that has a few examples for building JSON objects the contain arrays.  If none of these fit what you are looking for, could you provide an example of your desired outcome?

Thanks!

-Tasha

mdata · Accepted Answer

I found a custom macro prototype that's really useful.  Attached is the macro for the json create.  I have question as far as creating a loop when reading from a file and process x number of records and append it to a file and repeat the process until all records are done.   I will start that question as a new topic.   Thanks!