Alteryx Designer

Find answers, ask questions, and share expertise about Alteryx Designer.
Register for the upcoming Live Community Q&A Session - and don't forget to submit your questions for @DeanS regarding the future role of analytics here.
SOLVED

two columns from json output into one row

Highlighted
5 - Atom

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_NameJSON_ValueString
facets.0.namecontent_EAP_GREEN
facets.0.results.0.score1
facets.1.nameauthor_APP_GREEN
facets.1.results.0.score1
facets.2.namepublisher_APP_BLUE
facets.2.results.0.score1
facets.3.namepublisher_APP_GREEN
facets.3.results.0.score0.99000001
facets.4.namepublisher_APP_GREEN
facets.4.results.0.score0.959999979

 

here is what i need it to look like

NameScore
content_EAP_GREEN1
author_APP_GREEN1
publisher_APP_BLUE1
publisher_APP_GREEN0.99000001
publisher_APP_GREEN0.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

Alteryx Certified Partner

Hey @kevinbernard

 

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

 

Json.PNG

 

@LordNeilLord

Part time Tableau, Part Time Alteryx. Full Time Awesome


Data Lover

Highlighted
5 - Atom

Perfect. works like a champ. thank you!!

Highlighted
Alteryx Certified Partner
Great @kevinbernard

Would you mind accepting the solution?

Neil
Labels