Multiple filters that assign a new text column to file

tiverson

I am trying to assign values to each line of a large database with multiple filter criteria.  Each of the filters will assign a "title" to a new column

Any order number with "xfer, xfer1 or xfer2" will equal "Transfer"

Any Order type with FR will equal "Freight"

Any account number with 123, 124, or 125 will equal "FX"

Any text field that contains "FX" will equal "FX"

Any text field that contains "Freight" will equal "Freight"

How do I assign a Title to each row using multiple criteria?

Sample database:

Order number     Acct Number     Text              Title (new column)

xfer                     456                                          Transfer

xfer1                   457                                          Transfer

xfer2                   458                                          Transfer

GW1                   123                                          FX

GW2                   124                                          FX

GW3                   125                                          FX

GW4                    777                  FX                  FX

A1                        888                  Freight          Freight

A2                        999                  Freight          Freight

FR                                                                      Freight

Thanks,

Todd

mutama

Hi @tiverson,

Please find the workflow attached to the potential solution to your use case. The Formula Tool is key here 🙂

For more info on how to use the Formula tool to create the IF/ELSE logic shown in this sample workflow, take a look at our Tool Mastery article here: https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Tool-Mastery-Formula/ta-p/32675

Hope this helps!

Best,

Michael

Alteryx Discussion_Designer_tiverson_June 23.yxmd