Advent of Code is now back for a limited time only! Complete as many challenges as you can to earn those badges you may have missed in December. Learn more about how to participate here!
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Replicate the Excel “contains” logic in Alteryx

EmilAlteryx01
8 - Asteroid

Hi, 

How do i replicate the Excel “contains” logic in Alteryx, where I want the output to only include all items from Input 2 - if the AreaCode from Input 1 (e.g., 81730A108) is contained within the AreaCode_intrl_Number column from Input 2 (contains 11 rows if done manually)

My Designer does not have the "Custom Condition" option in the Join tool

 

Input 1 - 

Inventory Check DateInventory CountBrandAccount CodeAreaCode
05-May-2519Nike7520811181730A108
05-May-251230Nike7520811176425N101
05-May-25202Puma6563221170480Z301


Input 2

AccountAreaCode_intrl_NumberStoreLocationQtyPlusCheck
752-08111-181730A108000INZ5587
752-08368-581730A108000INZ50
798-00081-081730A108000INZ50
798-00081-181730A108000INZ60
798-00081-281730A108000INZ55
798-00081-581730A108000INZ22
798-00081-581730A108000INZ30
798-00081-095830A108000INZ140
752-08368-576425N101000INZ130
752-08368-281730A108000INZ30
752-08368-2770480Z301MNNINZ10
753-08368-270480Z301000INZ5
753-08568-270480Z301000INZ220
752-08111-281730A108000INZ19
752-08111-281731A108000INZ19
752-08111-276425N101000INZ1230
752-08111-281730A108000INZ550
752-08111-272130A108000INZ33
656-32211-270480Z301000INZ200
752-08111-281730A108000INZ25
752-08121-570480Z301000INZ80
752-08121-376425N101XMNINZ100
656-32211-280580Z301000INZ112
656-32211-180580Z301000INZ12
686-32211-180580Z301000INZ44
656-32211-270480Z301000INZ10
656-32221-270480Z301000INZ10
897-32221-270480Z301000INZ10
897-32221-170480Z301000INZ10
897-32221-070480Z301000INZ5
2 REPLIES 2
alexnajm
18 - Pollux
18 - Pollux

Use a Find Replace to match on Any Part of Field and append the column to the data, then use a Filter to only keep the matching rows!

EmilAlteryx01
8 - Asteroid

Hi Alex., Thank you so much ..

This Solution worked 

Labels
Top Solution Authors