14 Replies Latest reply: Apr 29, 2015 3:06 AM by Marcus Sommer RSS

    Null values needs to be sorted at last..if replaced with some value

    Ankita Agarwal

      Hello All,


      My script is



      Mapping Load


      from excel1;



      Table 1:

      Load Id,Name,Login Date,countofLogins, applymap('Mappingtable',Id,'Unknown') as Region

      from excel2;


      Here, since I have used 3rd parameter as Unknown so null values will be replaced with Unknown.

      Problem is :

      At frontend when I sort my table on the basis of countofLogins..Unknown comes 1st in the Region as it contains the maximum of count.


      Is there any way to keep it at last?

      Hope I made it clear..


      Thanks and Regards,