Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have the following Dimension:
=IF(WildMatch ([LINE_ITEM_ADJUSTMENTS], '*CO-107*',
), 'Registration Error')
Can I write this expression to include multiple if wild match conditions?
Such as:
=IF(WildMatch([LINE_ITEM_ADJUSTMENTS], '*CO-107*','Registration Error'),
IF(WildMatch([LINE_ITEM_ADJUSTMENTS], '*CO-24^*', 'Captation')))
Thanks in advance.
Try
Pick(WildMatch ([LINE_ITEM_ADJUSTMENTS], '*CO-107*', '*CO-24^*'), 'Registration Error', 'Captation')
Regards!
I have about 25 categories to assign, so it needs to be like nested if statements.
And there could be multiple categories to each row.
if the expression I sent works with 2 it can work with as many as you want
Pick(WildMatch ([LINE_ITEM_ADJUSTMENTS], '*CO-107*', '*CO-24^*','cat3*','cat4', etc...), 'Registration Error', 'Captation','Category 3','Category 4',etc.)
What if the categories have multiple wild match criteria?
You can do something like this:
Pick(WildMatch ([LINE_ITEM_ADJUSTMENTS], '*CO-107*', '*CO-24^*','criteria3.1*','criteria3.2*','cat4', etc...), 'Registration Error', 'Captation','Category 3','Category 3','Category 4',etc.)
If you don't want to create a long calculated dimension you can use the same in the script or try to use a mappping/applymap depending in how many diferent criteria values you have.