Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

two columns from json output into one row

kevinbernard
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

3 REPLIES 3
LordNeilLord
15 - Aurora

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

kevinbernard
5 - Atom

Perfect. works like a champ. thank you!!

LordNeilLord
15 - Aurora
Great @kevinbernard

Would you mind accepting the solution?

Neil
Labels