In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests after December 31, 2025. Set up your security questions now so you can recover your account anytime, just log out and back in to get started. Learn more here
Start Free Trial

Alteryx Designer Desktop Discussions

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

Parsing columns using Regex

jay_viz
7 - Meteor

I have a workflow that extract AirBnb data from URLs and find out if certain features are offered in a listing. For example I am looking to see if a listing offers WiFi (Case Insensitive) or Dedicated Workspace or Long Term Stay Allowed. Final data appears as below, counting them as 1 or 0 based if these features are offered for a listing. 

 

I got first few things working, and I am stuck where how I could parse specific features and put 1 and 0 against them in the output. I have attached workflow I am using.

 

IDURLWiFiLong Term StayDedicated workspace
16910794https://www.airbnb.com/rooms/16910794100
12654250https://www.airbnb.com/rooms/12654250101

 

Thank you for the help

2 REPLIES 2
Raj
16 - Nebula

Hi,

Please find the solution for reference, Hope this helps

 

jay_viz
7 - Meteor

@Raj Thanks, what I was hoping to get is how can we extract the features I am interested in from the Regex. If you see 2nd Regex it randomly pick 3 columns in the output. I was trying to get a method to look for the features we care about as an output from there.

Labels
Top Solution Authors