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