I've tried using rank function in magic ETL, but it also counted the once without data. Please see output. Can someone help me on this.
Worse case if you cant get the function of work in one step:
Split in to two using two filter tiles. Keep in mind that empty string cells are considered different to null, allow for both if need be.
Rank the stream one without nulls.
Append the two streams together.