two columns from json output into one row

[kevinbernard]

The data below represents two values (Name, score) for 4 different sets of data. I'd like to have the output into 4 rows

here's the original data

JSON_Name	JSON_ValueString
facets.0.name	content_EAP_GREEN
facets.0.results.0.score	1
facets.1.name	author_APP_GREEN
facets.1.results.0.score	1
facets.2.name	publisher_APP_BLUE
facets.2.results.0.score	1
facets.3.name	publisher_APP_GREEN
facets.3.results.0.score	0.99000001
facets.4.name	publisher_APP_GREEN
facets.4.results.0.score	0.959999979

here is what i need it to look like

Name	Score
content_EAP_GREEN	1
author_APP_GREEN	1
publisher_APP_BLUE	1
publisher_APP_GREEN	0.99000001
publisher_APP_GREEN	0.95999998

I tried using the ARRANGE step is it worked perfect BUT the data may change it that step will fail on me so i need another solution to pair the two values. any ideas would be appreciated

[LordNeilLord · Accepted solution]

Hey @kevinbernard

Using Text to columns followed by Crosstab will give you the result you are looking for :)

@LordNeilLord

Part time Tableau, Part Time Alteryx. Full Time Awesome

[kevinbernard · Accepted solution]

Perfect. works like a champ. thank you!!

[LordNeilLord · Accepted solution]

Great @kevinbernard

Would you mind accepting the solution?

Neil