How to Rename JSON fields with the Select Tool (or any Tool)

[carltonp]

I have ingested a JSON file from Azure Data Lake using the Azure Data Lake File Input tool. I would now like to make some changes to the fields or should I say key/value pairs.

In order to make the changes, I would like to convert the JSON to a table with fields e.g JSON syntax { "name": "John", "age": 22, "gender": "male", } with fields name, age, gender

name	age	gender
John	22	male

At present I'm attempting to achieve this using the Parse JSON tool. In my live scenario I would like to use an Alteryx tool to remove the key/value pair "JSON_Name":"url"

Any thoughts on how to achieve this?

[Felipe_Ribeir0 · Accepted solution]

Your output from azure data lake input tool is something like that, right?

The JSON component will create this numeric index for each {}/row, so you can know exactly about wich json/row you are dealing with.