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.
Essentially, the iInput tool will parse the JSON field into JSON Names and JSON Values – JSON Name is a listing of all the columns in the dataset (each occurrence) and JSON Value has the row value corresponding to each.
To get them in standard tabulated format, you’ll want to cross tab with JSON Name being the Header and JSON Value being the values.
I have attached sample workflow (Alteryx 10.6) to get the desired format.