2 Replies Latest reply: Aug 25, 2014 4:43 AM by Deepa V RSS

    Unexpected data in loading data from 2 tables using Key

    Deepa V

      Hello Team,

       

      I am loading data from 2 tables using a key (combination of 5 fields) in load statement.

         TRCK_TRAK_NO &'_'&TRCK_LINE_NO&'_'&TRCK_JOB_FLAG&'_'&TRCK_MACHINE&'_'&Date(TRCK_DATETIME ,'MM/DD/YYYY HH:MM:SS') as key,

      BT_TRAK_NO&'_'&BT_LINE_NO&'_'&BT_RXCNC_FLAG&'_'&BT_RXCNC_MACHINE&'_'&Date(BT_RXCNC_DATETIME,'MM/DD/YYYY HH:MM:SS') as key

      in which one table is a subset of other.

       

      when i display the entire data in Table chart I am seeing data as below:

      2014-08-25_121524.png

      Table View:

      2014-08-25_121920.png

       

      When I select any of the parameters, it is perfect. but when i do 'Clear Selection', I don't want to see the marked above section.

       

      Please help me in getting rid of this.

       

      Thanks,

      Deepa