Join the Alteryx Community’s Maveryx Summer Cup event! Compete, network with others, and earn your gold through a series of challenges from July 24th to August 11th. Learn more about the event here.
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.
community Alteryx IO Alteryx.com
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
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

Status: Accepting Votes Submitted by on ‎12-19-2019 06:58 AM
1 Comment (1 New)

 

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?

See more ideas labeled with:
Labels