31 Replies Latest reply: Nov 9, 2016 10:35 PM by Jim Chan RSS

    How to track records that have changes in some columns.

    Jim Chan

      Hi guys,

       

      I have posted up this question b4. but no answer yet.

       

      For example . i have 2 years of data loaded in. 2015-2016.

       

      Take ID 003 as example: in year 2015, category column is charlie and locatin column is shop

       

      in year 2016, ID 003, category changes to delta and location change to Toilet.

       

      I need a text object to count all these ID that has changed. and a table box that show which ID has changes in category and location column.

      screenshots.jpg