2 Replies Latest reply: Aug 16, 2012 12:20 PM by ralphkomer RSS

    Mark first instance of Value during Load

    Mark Orchard

      Hi

       

      I am loading in a data file that contains a receipt number.  This number is duplicated against multiple lines.  To try to speed up calculations i am looking to populate a new column during the load with a 1 on the first instance of a new receipt number and a 0 on all duplicate lines.

       

      I know I can do this via count(distinct in expressions but want to leverage to speed of sum by utilising 1 and 0 's.

       

      Many thanks

       

      Mark