Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Ideas

Share your Designer Desktop product ideas - we're listening!
Submitting an Idea?

Be sure to review our Idea Submission Guidelines for more information!

Submission Guidelines

Contains with multiple strings and targets

 

Example Data:          
MJE Text  Ref Fld 1 Ref Fld 2 Ref Fld 3 Date NTID
Accrual MJE Load     11/1/2019 DAVET
Fx Reval Accrual     12/2/2019 MOLLYI
    Acc   3/4/2019 BOBH
Forex Fx     CCRUAL 7/9/2019 GREGA
FASB       8/5/2019 BOT7
Tax       10/6/2019 BOT88

 

I want to use contains to search multiple strings and "IN" for multiple targets within the same formula. 

 

IF Contains(([MJE Text]+[Ref Fld 1]+[Ref Fld 2]+[Ref Fld 3) IN("Accrual","Acc","CCRUAL")) THEN "Accrual" ELSE "" ENDIF

 

Result would be:            
MJE Text  Ref Fld 1 Ref Fld 2 Ref Fld 3 Date NTID Group
Accrual MJE Load     11/1/2019 DAVET Accrual
Fx Reval Accrual     12/2/2019 MOLLYI Accrual
    Acc   3/4/2019 BOBH Accrual
Forex Fx     CCRUAL 7/9/2019 GREGA Accrual

 

Can this be developed?

1 Comment
AlteryxCommunityTeam
Alteryx Community Team
Alteryx Community Team
Status changed to: Accepting Votes