Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
There is a field called 'Price'that contains values such as FOB/collect, FOB/prepaid, COD/prepaid, DEST/prepaid & collect, amongst others
I am needing set a flag if any of the values contain a certain string, such as 'prepaid'. Currently I have tried match and mixmax in my load script to load a new field as either 0 or 1, depending if there is a match
MixMatch('prepaid',[Price]) as .Prepaid
Try this may be:
If(WildMatch(Price, '*Prepaid*'), 1, 0) as PrepaidFlag
Try this may be:
If(WildMatch(Price, '*Prepaid*'), 1, 0) as PrepaidFlag
I also just figured out my issue, which is similar to yours
WildMatch([Price ],'*prepaid*') as Prepaid
I am getting a 1 in Prepad when true and 0 if False
Thanks for your 1uick response