how to use rank function that ignore null or blank data


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.



  • rado98
    rado98 Contributor

    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.