5 Replies Latest reply: Jul 23, 2014 5:16 AM by sujeet singh RSS

    distinct row count

      below is the sample table

      CAL:

      Load * INLINE [

      days,no

      Jan,1

      Feb,1

      Mar,3

      Apr,2

      May,4

      Jun,4

      Jul,5

      Aug,6

      Sep,7

      Oct,8

      Nov,9

      Dec,5

      ];

       

       

      i want to get thhe distinct count of column "no"

       

      at script level i am using

       

      let vvar = count(DISTINCT no);

      trace >>> countof: $(vvar);


      but log file show null


      plz provide any solution for the same the required answer should be "9"