Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
GELÖST

Parsing Data

SteveFord
Meteor

Hey all,

 

I have a dataset that has one column with a long sting of text as per the file upload. I need to parse the data out in to columns as below (I only need those fields) so the column name is the field name and values as in the text answers:

 

"phone_field": ["19148475887"]

"postcode_field": ["10591"]

"country_field_gen": ["United States"]

"jobtitle_field": ["Compliance Counsel"]

"email_field": ["brooke.sherer@regeneron.com"]

"company_name_field": ["Regeneron Pharmaceuticals"]

"surname_field": ["Sherer"]

"firstname_field": ["Brooke"]

"thirdparty_consent_field": ["Consent Not Asked"]

5 ANTWORTEN 5
usmanbashir
Bolide

@SteveFord - please see attached workflow. Hope this helps!

SteveFord
Meteor

Sorry, if you look at the file uploaded the text comes in one column in a big long string. I need that parsed out to columns.

usmanbashir
Bolide

@SteveFord - sorry misread. Here you go!

 

 

**disregard this message - wrong workflow attached

adamweaver39
Comet

Hey @SteveFord , including my workflow that specifically works with your file. Hope this helps. Probably a more elegant solution out there, but this solution seems parsable!

usmanbashir
Bolide

@SteveFord - apologies - I previously attached the wrong workflow. Here you go. The data is just JSON so you can you JSON parse. See attached workflow.

Beschriftungen
Top-Lösungs-Autoren