All tagged Pivoting

Converting JSON data into flat structure using Alteryx

JSON or JavaScript Object Notation is an open-standard text-based storage format derived from JavaScript. The data is stored in Name-Value pairs. Some architects and developers prefer data in JOSN format because of its simple syntax.

But sometimes to analyze the data or do some testing or manipulation, we might need this data in a tidy Two – Dimensional flat structure where the column headers are on the top followed row level values like a standard Excel or CSV format. IN this blog, we will discuss about using Alteryx to convert the JSON file into a flat structure.