The Product Idea boards have gotten an update to better integrate them within our Product team's idea cycle! However this update does have a few unique behaviors, if you have any questions about them check out our FAQ.

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