topic Create Yes/No Column based on Find String in Alteryx Designer Desktop Discussions

Create Yes/No Column based on Find String

jhan — Thu, 21 Mar 2019 15:31:14 GMT

Hello

I am trying to create a table where it reads from the input, and creates the output as follows:

Input	Output
Features	Parking	Microwave	Dryer	Garden	Washing Machine	Exercise Room	Balcony	Parking	Dishwasher
Parking, Microwave, Dryer, Garden, Washing Machine	Yes	Yes	Yes	Yes	Yes	No	No	No	No
NULL	No	No	No	No	No	No	No	No	No
Exercise Room, Balcony, Parking, Dishwasher, Dryer	No	No	Yes	No	No	Yes	Yes	Yes	Yes

I tried using IF formulas and Find Strings, but to no avail; they only worked for the first feature type, and it started getting a little screwy.

There are quite a few categories of features, and it would be ideal if it can somehow figure out what is contained in the "Features" column.

If not, there is a list of may be 50-60 items that can potentially show up on the features section.

If someone can point me in the right direction, or suggestion, would greatly appreciate it!

Thank you,

Re: Create Yes/No Column based on Find String

yalmar_m — Thu, 21 Mar 2019 15:55:32 GMT

Hi @jhan,

This might be a solution for you? First you need to split to rows and transpose.

Then append all fields to your features and use the multi-field tool to identify matches.

Kind regards,

Yalmar

Re: Create Yes/No Column based on Find String

TrevorY — Thu, 21 Mar 2019 15:57:12 GMT

I've attached an example of how you might do this - I think the best way is to create a column for each of the possible amenities and create if/then statements for each one. I've attached a workflow that shows how you might go about this.

Re: Create Yes/No Column based on Find String

ChrisTX — Thu, 21 Mar 2019 16:00:10 GMT

There's probably an easier way, but the attached workflow gets the result you are looking for.

Re: Create Yes/No Column based on Find String

jhan — Fri, 22 Mar 2019 21:13:07 GMT

Thank you everyone for your help!

I am learning alot through this community!