4 Replies Latest reply: Jun 26, 2017 2:54 PM by Capatina Sterica RSS

    COUNT column

    Capatina Sterica

      Hello,

       

      I have this table:

       

      LOAD * inline [

      Customer|Product|OrderNumber|UnitSales|UnitPrice

      Astrida|AA|1|4|16

      Astrida|AA|7|10|15

      Astrida|BB|4|9|9

      Betacab|CC|6|5|10

      Betacab|AA|5|2|20

      Betacab|BB|1|25| 25

      Canutility|AA|3|8|15

      Canutility|CC|||19

      Divadip|CC|2|4|16

      Divadip|DD|3|1|25

      ] (delimiter is '|');

       

      I just want to count Astrida from the column Customer

      I tried with: count(Customer='Astrida') but not work.


      Thank you!