3 Replies Latest reply: Aug 6, 2015 10:27 AM by Dipesh Patel RSS

    Create historic table based on changes on field

    Dipesh Patel

      Hi,

       

      Background:

      Table 1:

      IDNameStatus
      1test 1TBD
      2test 2TBD

       

      Historic data of Table 1:

      Table 2:

      IDChange DateStatus
      101/08/2015Change

       

      How can i join or concatenate additional data (Historic) to Table 2 based on change date. So historic table looks like

      IDChange DateStatus
      101/08/2015Change
      107/08/2015Passed
      207/08/2015Change

       

      Hope someone can add some insight with an example.

       

      Thanks,