2 Replies Latest reply: Nov 14, 2012 3:01 AM by guillaumek RSS

    Problem multiples data in tables Viewer

      Hi, I have a problem in my tables viewer; so in my script.

      This is my tables:

      FOR each vFile in filelist('$(vCheminData)FILE.DAT')

      TMP_WORKFLOW:
      LOAD
             text([Division] & '-' & [Num]) AS %NumComplet,
             [step Code] AS [Code Step],
             [Service Code] AS %CodeService
        FROM $(vFile) (txt, codepage is 1252, embedded labels, delimiter is ';', no quotes);
           
      D_WORKFLOW:
           LOAD * INLINE %NumComplet;
      JOIN(D_WORKFLOW) LOAD
             %NumComplet,
             [Step Code],
             %CodeService
      RESIDENT TMP_WORKFLOW;

       

      STORE D_WORKFLOW INTO '$(vCheminQVD)D_WF.qvd' (QVD);
      DROP TABLE TMP_WORKFLOW;
      NEXT vFile

       

      TMP_SERVICE:
        LOAD
             [Code Service] AS %CodeService,
             [Name Service],
             [Code Service] & ' - ' & [Name Service] AS Service
        FROM $(vFile) (txt, codepage is 1252, embedded labels, delimiter is ';', no quotes); // (.DAT)

      M_SERVICE:
      LOAD * INLINE %CodeService;
        JOIN(M_SERVICE) LOAD
             %CodeService,
             [Name Service],
             Service
           RESIDENT TMP_SERVICE;

      STORE M_SERVICE INTO '$(vCheminQVD)M_SERVICE.qvd' (QVD);
      DROP TABLE  TMP_SERVICE;
      exit script;

       

      And, when i reload and open my tables viewer, i have like 200 times the same value if i make a right click on Services table....

      And i should have only one value for each %CodeService.

      I have this problem for each secondary tables with common key in my other files too.

       

      Do yo see the problem ?

       

      Thanks by advance