No More Singing the JSON-Parsing Blues

It’s a little-known secret that when blues guitarist B.B. King wrote his famous song, “The Thrill Is Gone”, he was referring to analyzing JSON data.?

Ok, that may be a bald-faced lie, but the fact that JSON can give analysts the blues is not.?

JSON has its benefits as a human-readable, concise, and widely-accepted language for data interchange, but its structure does not lend itself to easy data analysis.?

Savant offers a simple solution that allows you to flatten fields and explode rows of JSON data with the click of a button.?

Savant JSON Flatten Fields

Once you’ve uploaded or connected your JSON dataset to your Savant Analysis, you can begin to parse the data by selecting the JSON tool and flattening fields to visualize each column within the dataset better.?

With the dataset in the following video, we’ll use the flattening fields option to break out our data into columns showing blues musician name (text string), birth year (integer), rock and roll hall of fame (boolean), and sample songs (test string array).?

Notice that Savant also takes into account the various column data types, and leaves null values blank.

Savant JSON Explode Rows

If your JSON data contains arrays, it is just as easy to explode rows with the same JSON tool.

In the video below, we’ll use the row exploder option to break out each array of sample songs data into a separate row.

Go to savantlabs.io and try Savant today!