Define filtered item in new column

[tiverson]

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 solution]

Hi @tiverson 

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

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

then "Transfer"

else null()

endif

[anupgupta12]

You can leverage formula tool, use expression "contains" .

Put a formula - add a column - put expression  If contains[order number], "XFER") THEN "transfer" ELSE "" ENDIF