4 Replies Latest reply: Dec 19, 2012 10:28 AM by Marina Alvarez Ruiz RSS

    Compare 2 or more historical fields for tracking purposes

      Hi,

       

      I need some help comparing tables and outputting the differenses to track changes. I store away all orders with ordernumbers, orderrows and productid every day 5 days back and delete anything older. I need to load all these files and compare them to one another and present the changed orderrows in a chart.

       

      If the loaded table has this in it:

       

      Savedate     Orderdate     Ordernbr     Row     ProductID     Qty

      110501        110301          12345        10        5555            4

      110503        110301          12345        10        4444            4

       

       

      Then that change should be visible in the chart

       

       

      Although theese two rows:

       

      Savedate     Orderdate     Ordernbr     Row     ProductID     Qty

      110511        110401          15555        10        3333            3

      110513        110401          15555        10        3333            3

       

      Would'nt generate any output in the cart

       

      So basically: I want to compare a row with every other row with different SaveDates and see if there is any changes in Qty or/and ProudctID. If there is, show it in a chart.

       

      How would the expression for doing this look like? I'm feeling very stuck with this