Almost the same approach as Mark, using substringcount and creating a final table:
LOAD * INLINE [
abc123Abandoned Cart_xiyudhu289192, 58973
asdasd234Abandoned Cart_xihu282392, 58975
JOIN (A) LOAD * INLINE [
CampaignName, Cost, Date
Abandoned Cart, 3108, 41468
Browers, 827, 41468
drop table A;
Well it's good practice to use numbers for the key fields. So I've done this in my revised version (attached).
I would just give it ago and see what happes...
sample_2.qvw 152.8 K