This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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?
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!