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

       

      Mappingtable:

      Mapping Load

      Id,Region

      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,

      Ankita