3 Replies Latest reply: Oct 7, 2014 1:59 AM by Jonathan Dienst RSS

    Connect data from few tables

    Андрей Шепель

      Good day!

      In load script i load two tables:

       

      Directory;

      FOR Each File in filelist ('C:\ProgramData\QlikTech\QlikViewServer\Audit__*.log')

      Data_from_Audit_files:

        LOAD [Server Started],

            Timestamp,

            Capitalize(Document) as Document,

          Type,

          User,

            Message,

           SheetCode,

            ObjectCode

       

        FROM

        '$(File)'

        (txt, utf8, embedded labels, delimiter is '\t', msq);

      NEXT File;

       

      Directory;

      Info_Sheets:

       

       

      LOAD Capitalize(FileName) as Document,

           Sheet,

           SheetID as SheetCode,

           SheetName,

           ObjectId as ObjectCode,

           Label as ObName

               

      FROM

      [for Audit\Sheets1.xlsx]

      (ooxml, embedded labels, table is Sheet1);

       

      Loading is successful. But when i choose ObName, i don't see any data in fields Type,User, Message,Timestamp...

      What i do wrong ? How i must connect these tables?

       

      Thanks

       

      ,

        • Re: Connect data from few tables
          Jonathan Poole

          Seeing the  QVW will help. 

           

          Either the values for 'document' are not the same between the 2 tables or the  documents that were selected have not been used on the server (and have no log references)

           

          I suggest adding a 2nd document field in each load named differently

          IE:

              

               Capitalize(Document) as [Document-AuditFiles],

           

               Capitalize(FileName) as [Document-Sheets],


          Then add both these fields as list boxes and start clicking them to see if the values associate.

            • Re: Re: Connect data from few tables
              Андрей Шепель

              No, 'Document' field from both tables is the same and data is connected correctly by this field.

              Also data is connected correctly by other key fields (SheetCode,ObjectCode).

               

              My task - when i choose some data in ObNaame field to see:

              Timestamp,

              Capitalize(Document) as Document,

              Type,

              User,

               

              from 1 table. (not it's not available)

               

              There's structure in attachment !

                • Re: Connect data from few tables
                  Jonathan Dienst

                  Hi

                   

                  Because of the composite key, all 3 fields must be matching in both tables for there to be any association between a value in one table and values in the other table. Hover over the $Syn1 field in each table and see the subset ratio in each table. If they add up to 100%, then there is no association between the tables. If either of them contain less than 100%, then there are non-associated rows in the other table.

                   

                  If you post your model or a sample that illustrates your problem, then someone will be able to help in more detail. It might be useful to post the spreadsheet and a couple of your log files.

                   

                  HTH

                  Jonathan