Creating additional field that identifies Flats & Apartments

Hi There,

I'm relatively new to Alteryx and I'm looking to create a new field within my data that flags records where flat, apartment or variants of are within the address fields.

In MS Access I would run the query as shown in the screenshot attached. Flat query.PNG

How would I go about doing this please?

Many thanks in advance.

Datasets

Join

Optimization

Accepted answers

jamielaird

Hi @JamesDB

Here's a simple example of how you could approach this:

Screenshot 2019-07-04 at 10.33.30.png

Example workflow attached.

Cheers,

Jamie

Apartment.yxmd

All comments

andyuttley

Hi @JamesDB

One method would be to use a Contains([YourField], "Flat") function in a formula, e.g.:

IF Contains([YourField], "FLAT") then "Flat"

elseif Contains([YourField], "APARTMENT") etc...

Let me know if you want an example

Andy

jamielaird

Hi @JamesDB

Here's a simple example of how you could approach this:

Screenshot 2019-07-04 at 10.33.30.png

Example workflow attached.

Cheers,

Jamie

Apartment.yxmd

JamesDB

Hi Andy,

Many thanks for your input.

James

Quick Links

This months top contributors

AkimasaKajitani 389

mceleavey 388

mbarone 337

Hollingsworth 335

LanisC 335