This content has been marked as final. Show 2 replies
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.