Check number of values and return value

Question

Hello,

I have a data set that I need to check the number of characters in a specific column, then return a value.

I want to check the Assignment column for 18 digits (including the slash)

Data:

Output:

Create a new column title "Contract type"

In Contract type column add the following values"

1 - If there is not 18 digits or blank, then default to "Fleet" for contract type

2 - If there are 18 digits then check the 5th digit.

3 - If 5th digit is 1 then "Fleet", if 2 then "Machinery", if 3 then "Other", if 4 then "Real Estate"

Alteryx parse solution.xlsx

DataNath · Accepted Answer

Hey @tiverson, does this look like what you're expecting?

Quick edit: With the above approach, this assumes that there's only ever 1/2/3/4 as the 5th character. If you need it to handle more possibilities then you can use the below. It's currently set to null() anything not 1-4 so just change that to whatever it needs to be.