Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone
I'm having a little troble in my script. I have the following example list of values in a field called "Campaign Type":
Sage Vendor, Microsoft Vendor, Digital Campaign, Pegasus Silo, Sage Silo (there are more but will serve for this)
What I want to do is create another field called "Campaign Group". The Campaign Group will be specified as follows:
1. Anywhere the word "Vendor" appears let Campaign Group = Vendor.
2. Anywhere the word "Silo" appears let Campaign Group = Silo
3. Anywhere the word "Digital" Appears let Campaign Group = Digital
So each row is either a Vendor, Silo or Digital Campaign.
I could do a lengthy IF statement for each campaign type but I have a few of them and more could be added. I'm happy for it to be an IF statement though if I can just group up the Campaign Types.
I've tried a few things like substringcount but I can't seem to get anywhere so I was hoping for a push in the right direction.
Thanks
Stu
Hi
In your script:
Pick(WildMatch([Campaign Type], '*Vendor*', '*Silo*', '*Digital*')+1, 'Other', 'Vendor', 'Silo', 'Digital')
as [Campaign Group]
Regards
Jonathan
Hi
In your script:
Pick(WildMatch([Campaign Type], '*Vendor*', '*Silo*', '*Digital*')+1, 'Other', 'Vendor', 'Silo', 'Digital')
as [Campaign Group]
Regards
Jonathan
That's great Jonathan thanks for such a quick response. I was going to ask you how that works as I didn't get the significance of the +1 but I've took it to bits and found the logic behind it.
Thanks again.
Stu