4 Replies Latest reply on Oct 12, 2018 5:02 PM by Shai Rosenzvit

    Getting rid of 'Invalid' records

    Shai Rosenzvit

      Hi, I have a data source which contains the purchase activity for users of my site.

       

      The problem is that I have some records which are not valid for when the payment didn't go through or some other problem. These are identifiable by having the same 'Id Transacc Net' but a lower 'ID generacion' as you can see in page 2.

       

      I've identified them doing a table calculation called 'Pivot' but if I change the Viz, they stop being labeled as invalid.

       

      I need to eliminate this records because they mess up the analysis I need to do of each user activity. Could somebody help me with this problem?

       

      Best regards

       

      Shai

       

      P.S. The data source gets updated daily, but I extract it to deal with the sheer number of records, don't know if this changes anything. To be able to attach it here I have left the data live, since the file was too big otherwise