Create Yes/No Column based on Find String

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,

Parse

Transformation

Preparation

Accepted answers

ChrisTX

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

Create Yes No Column based on Find String.yxmd

All comments

yalmar_m

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

Solution.yxzp

TrevorY

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.

Parsing Example.yxmd

ChrisTX

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

Create Yes No Column based on Find String.yxmd

jhan

Thank you everyone for your help!

I am learning alot through this community!

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703