Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi,
i need to know how to script a expression to count the number of times a word appears in a column?
could you please assist?
=Count(if(Comments,'*BlackBerry*'))
Try:
Sum(if(Comments = '*BlackBerry*', 1 , 0))
let me know
Hi Marvin, for a sample data like:
LOAD * Inline [
words
BlackBerry
aid BlackBerry
BlackBerry 2
other words
];
You can use an expression like:
=Sum(Aggr(If(Index(words, 'BlackBerry'), 1, 0), words))
This is better:
Sum(if(WildMatch(Comments, '*BlackBerry*')>0, 1 , 0))
hi ,
Thanks Alessandro it works ...... awesome stuff....
thanks i will do this for the inline .... awesome stuff