Define filtered item in new column

Question

Hello, I have a data set that has a column for Order Number.

I want to filter for specific values, then assign text to those rows in a new column

Order number                TOPIC (new column)

XFER                             Transfer

XFER2                           Transfer

XFER3                           Transfer

NEW

NEW1

NEW2

If I want to specifically look for lines that contain XFER, XFER2 and XFER3, then assign the text Transfer  in a new column titled TOPIC

Thanks,

Todd

Luke_C · Accepted Answer

Hi @tiverson

You could use a formula tool to check for records containing XFER

if contains([Order Number],"XFER")

then "Transfer"

else null()

endif