Creating additional field that identifies Flats & Apartments

[JamesDB]

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.

How would I go about doing this please?

Many thanks in advance.

[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 · Accepted solution]

Hi @JamesDB 

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

Example workflow attached.

Cheers,

Jamie

[JamesDB]

Hi Andy,

Many thanks for your input.

James